Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Thanks to all who attended the SSUG meeting in Edinburgh last night. I've included my slides and demo scripts in the attached file (SSUG_190810_ExecutionPlans.zip). I've also included some additional references relating to discussions we had during the course of the evening. If you need any other information, give me a shout.
Creating a Statistics-only "Cloned" Database:
https://support.microsoft.com/kb/914288
https://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx
Database Tuning Advisor (DTA) - Reducing the Production Server Tuning Load
https://technet.microsoft.com/en-us/library/ms190389.aspx
Optimizing tempdb Performance
https://msdn.microsoft.com/en-us/library/ms175527.aspx
Improving Performance of Dynamic SQL
https://msdn.microsoft.com/en-us/library/ms175170(SQL.105).aspx
https://msdn.microsoft.com/en-gb/magazine/ee236412.aspx
See you all at the next meeting !
Rob
SSUG_190810_ExecutionPlans.zip
Comments
- Anonymous
January 01, 2003
A great Scottish Area User Group last night here are the slide decks