The solution to my puzzle on why statistics are not updated but are created once after a large insert, even with auto update on, and the fix that worked for me.
SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
A puzzle for you: auto update is on and I insert 10 times more rows, yet the statistics are not updated. Why, and how can they update automatically?
SQLAuthority News – Solid Quality Journal – Importance of Statistics
My Solid Quality Journal article on the importance of statistics covers when to update statistics, sync and async updates, and the auto settings.
SQL SERVER – Get File Statistics Using fn_virtualfilestats
Which MDF or NDF file is the busiest? This query uses fn_virtualfilestats to show reads, writes, IO stalls and size for every database file.
SQL SERVER – Copy Statistics from One Server to Another Server
Without the client’s data, every query ran in zero milliseconds. Here is how I copy statistics from one server to another to tune with only the schema.
SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010
I am speaking at Virtual TechDays on Nov 22, 2010 on Statistics and Best Practices, from the basics to common questions. The online event is free.
SQL SERVER – Find Automatically Created Statistics – T-SQL
Ad-hoc queries on a production server left many useless automatically created statistics. Here is a T-SQL script to find them so you can clean them up.