-
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
-
Rowcount estimates when there are no Statistics
When you don’t have statistics, what does SQL use to calculate the estimated number of rows? 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
-
How does Query Store capture cross database queries?
Query Store is a configuration that is enabled per database, and the plans and stats for queries executed in that database are stored in the database itself. So what does query store do when a query spans more than one database? Read more
-
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as well as view data that traditionally would have been lost due to server restarts, recompiles etc. Read more
-
SQL Puzzle – Eight Queens on a Chess board
Here’s a SQL Puzzle for the festive period. 2020 has been a year of many things but amongst it all, it has been the year of chess. The combined effects of the pandemic and The Queen’s Gambit on Netflix have given rise to a level of interest in the game not seen for generations. So… Read more
