Archive:
- August 2026 (3)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Compilation (1) Concurrency (3) DMVs (1) docker (2) Execution Plans (5) Indexes (2) internals (11) linux (3) Name Resolution (1) Optimization (5) Performance (8) Performance Tuning (2) pgadmin (1) postgres (5) RCSI (2) SQL Server (20) Statistics (2) Transactions (1) tsql2sday (1) Version Store (2)
Categories:
Tag: Statistics
-
In a Query Plan Near You – Stats Loaded For Compilation
Something I have been making use of recently is the change in the way statistics that have been used to compile a plan are presented to us as SQL Server users. On a number of occasions I have needed to understand, or at least get some sense of, which statistics SQL Server has used to…
-
Understanding SQL Server Statistics
The next post in this short introductory series is about statistics in SQL Server – this isn’t an all-encompassing deep dive into the topic – the aim is to outline what statistics are, where and how SQL Server uses them, present a quick overview of an example statistic and an example of statistics at work.…