-
Manually updating Statistics in SQL Server
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you want to manage updating them yourself. Read more
-
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly affect your cardinality estimation in some cases and therefore your execution plans. The Ascending Key Problem relates to the most recently inserted data in your table… Read more
-
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it’s useful for us to understand when statistics get updated – and where we might have to update them ourselves. This post details in what scenarios statistics get updated, as well as the… Read more
-
What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are and how they are used. Read more
-
Indexes and Statistics with Always Encrypted
In this short post we look at the ability to be able to have (or not) indexes on columns encrypted using Always Encrypted. Read more
-
Under Promise and Overdeliver
If you under promise and overdeliver then you will always have happy clients. Read more
