Question: How to Enable Auto Update Statistics and Auto Create Statistics? Let us learn how we can fix that in today’s blog post.
SQL SERVER – CLONEDATABASE: Generate Statistics and Schema Only Copy of the Database
DBCC CLONEDATABASE in SQL Server 2016 SP1 and 2014 SP2 can generate statistics and schema only copies of a database, handy for troubleshooting query plans.
Error: Msg 1904 The statistics on table has 65 columns in key list
SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list. Let us learn how to fix in this blog.
How to Find Outdated Statistics? – Interview Question of the Week #081
How do you find outdated statistics? The honest answer is that ‘outdated’ is subjective. I explain why, and how I look at statistics instead.
SQL SERVER – The NOLOCK Question – Notes from the Field #117
NOLOCK is one of the most abused hints I see. In Notes from the Field #117, Stuart Ainsworth explains when Nolock makes sense and why overusing it is risky.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.