Query Optimisation
Notes from Code Camp on 13th Sept. Just a few notes that will give me some ideas to check out and use to create some more beginner level presentations. Presented by Mark Souza. Slides will be available on aucklandsql.com at some point soon, probably once TechEd 09 has finished. DMV - dm_exec_query_optimizer DBCC SHOW STATISTICS - find equivalent dmv/SQL 2005+ code AUTO_UPDATE_STATISTICS - turn off on high data turnover system using sp_autostart off Play with sample sizes, especially during development stage before going to prod. Will 10% sample size give you different statistics to a 2% sample size? sp_create_plan_guide_from_cache