Archive:
- September 2026 (4)
- August 2026 (8)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Concurrency (3) debian (2) docker (2) Execution Plans (6) Identity (1) Indexes (3) internals (11) linux (5) MongoDB (2) MR2 (2) Optimization (6) Performance (9) Performance Tuning (3) postgres (6) Powershell (2) RCSI (2) SQL Server (25) Statistics (2) Stored Procedures (1) Version Store (2)
Categories:
Docker (2) Linux (4) MongoDB (2) PostgreSQL (6) Powershell (1) SQL Server (25)
Tag: Indexes
-
Filtered Indexes and Plan Parameterization
In this post, we’ll look at how filtered indexes in SQL Server work when the query is parameterised on the column of the filtered index. The query The following query in the Stack Overflow 2010 Database, provided under cc-by-sa 4.0 licence from Stack Exchange Data Dump, will find all users with the name John whose…
-
OR predicates and Indexes
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 compatibility level 160 on a…
-
Understanding SQL Server Indexes
This post follows on from the previous two about execution plans in SQL Server, in those posts I covered what an execution plan is, what they tell us and why we might need to use them. Indexes are actually nothing at all to do with execution plans but when talking about one, you often end…