My photo
Auckland, New Zealand
Smurf sized geeky person with a penchant for IT, gaming, music and books. Half of industrial duo 'the craze jones'. Loves data, learning new things, teaching new things and being enthusiastic.

Tuesday, 15 September 2009

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

No comments: