Performance Dashboard
Produced: 28/09/2014 18:09:00
This is an incredibly valuable, and free, tool you can use with SQL Server in order to get a real feel as to how your server is performing, where to look for issues, and miscellaneous other nuggets of information.

I have been using this ever since it came out for SQL Server 2005 and there have been a few changes made along the way, but nothing too detrimental and therefore I’m now quite happily using the latest version instead.

Continued...
Merge Replication Commands in Pipeline
Produced: 21/09/2014 11:38:00
Ever been in one of those situations in which you see endless blocking whilst replication makes new generations and you’re left wondering if there’s a specific table causing it or whether it’s just generic replication volume which is causing your problem?

Continued...
Automatic Update Statistics Threshold
Produced: 14/09/2014 17:25:00
This is a trace flag I only learnt about recently which actually fixes something that has been a large bug bear of mine for quite some time.

Basically we all know that statistics are one of the most important things in SQL Server and therefore it’s also critical to know how they’re maintained.

Inside SQL Server, if you have Automatic Update Statistics turned on in your database, your statistics will be updated each time 20% of your data has changed. This flag changes that behaviour for the better.

Continued...
What Statistics Are Being Used
Produced: 07/09/2014 17:18:00
You’re running a query and you’re looking at the execution plan… it’s all well and good, there are tables, indexes, cardinality estimates… all manner of information. We know these are all derived from statistics and that our statistics should be kept up to date. But the question is… exactly which statistics were used or considered by the optimizer?

Continued...