What is the best way to combat poor performance in your SQL server? After twenty-plus years of working with SQL Server, I would answer "Education". The most frequent and most difficult cases of poor …
Understanding SQL Server Statistics
The most difficult part of publishing a monthly newsletter is to find a new and interesting subject to write about every month. While browsing the archive of all my monthly articles searching for …
Continue Reading about Understanding SQL Server Statistics →
SQL Server Backup Encryption
This morning I began writing an article about the new features in SQL Server 2014. I was seething with anger at Microsoft to have once more provided so many cool features for the Enterprise Edition …
Tune SQL Server Using Wait Statistics
When your SQL Server is not performing as well as you would like, the fastest way to find out what's wrong is to look at the wait statistics available in the dynamic management view …
Continue Reading about Tune SQL Server Using Wait Statistics →
SQL Server Implicit Conversions
I had two great successes this month in solving critical performance issues quickly. In both cases, performance was so bad that the applications hitting the database were unusable. Both solutions …
The Importance of Join Order on SQL Performance
The order in which tables are accessed by the query engine is a critical factor in query performance. Its importance is sometimes underestimated and join order is often overlooked when a query needs …
Continue Reading about The Importance of Join Order on SQL Performance →