Erin Stellato is a Senior Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003, providing support for SQL Server environments across a variety of industries including healthcare, insurance, finance and government. Erin is an active member of the SQL Server community as a presenter and blogger, and her interests include Internals, Performance Tuning, High Availability and Disaster Recovery.
Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don't accurately reflect the current contents of the table you'll get a poorly-performing query. How do you find out if statistics are correct, and what can you do if the automatic update of statistics isn't right for the way a table is used? … Read more