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:
Month: August 2026
-
OR predicates and Indexes
Last Updated: August 4, 2026 In this post, we will look at how SQL Server accesses indexes when an OR predicate is used. For this demo, I am going to use the Stack Overflow Database. I am using the large 2024 version provided under cc-by-sa 4.0 licence from Stack Exchange Data Dump and running in…
-
Four Flavours of Postgres Install – Part 4 (Windows)
This post is the next in a short series exploring the different ways we can install a PostgreSQL server. This time, we’ll look at a vanilla install on Windows – no Docker involved. The VM I’ll use the same spec VM as in the last post, which is sufficient for demonstration purposes: Firstly, let’s hop…
-
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…