SQL Server Thoughts from the Field

Rob's SQL Server & BI Blog

SSUG Presentation 19th August

SSUG Presentation 19th August

  • Comments 1
  • Likes

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:
http://support.microsoft.com/kb/914288
http://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
http://technet.microsoft.com/en-us/library/ms190389.aspx

Optimizing tempdb Performance
http://msdn.microsoft.com/en-us/library/ms175527.aspx

Improving Performance of Dynamic SQL
http://msdn.microsoft.com/en-us/library/ms175170(SQL.105).aspx
http://msdn.microsoft.com/en-gb/magazine/ee236412.aspx

See you all at the next meeting !

Rob

Attachment: SSUG_190810_ExecutionPlans.zip
Comments
  • <p>A great Scottish Area User Group last night here are the slide decks</p>

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment