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:
Database Tuning Advisor (DTA) - Reducing the Production Server Tuning Load
Optimizing tempdb Performance
Improving Performance of Dynamic SQL
See you all at the next meeting !