
Archive:
- November 2026 (6)
- October 2026 (6)
- September 2026 (5)
- August 2026 (8)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Availability Groups (3) Concurrency (3) debian (4) docker (2) Execution Plans (7) Indexes (4) internals (12) linux (7) MongoDB (2) MR2 (2) Optimization (7) Performance (9) Performance Tuning (3) postgres (8) Powershell (3) RCSI (2) SQL Server (32) Statistics (2) Version Store (2) windows server (3)
Categories:
Docker (2) Linux (5) MongoDB (2) PostgreSQL (8) Powershell (2) SQL (1) SQL Server (33) Windows Server (3)
Tag: internals
-
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.…
-
SQL Server Execution Plans Explained

In these articles, you will see me reference execution plans a lot – talk about them, provide screenshots etc. I assume that the reader has some level of knowledge about what an execution plan is, how to view them and how to understand them. This post is aimed at those readers who do not have…