Archive:
- September 2026 (5)
- August 2026 (8)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Concurrency (3) debian (2) docker (2) Execution Plans (6) Indexes (4) internals (11) linux (5) MongoDB (2) MR2 (2) Optimization (7) Parameterization (1) Performance (9) Performance Tuning (3) postgres (6) Powershell (2) RCSI (2) SQL Server (26) Statistics (2) Stored Procedures (1) Version Store (2)
Categories:
Docker (2) Linux (4) MongoDB (2) PostgreSQL (6) Powershell (1) SQL Server (26)
Tag: Optimization
-
Optimizing Window Functions in Derived Datasets
In this post, we’ll look at some interesting behaviour I’ve stumbled across with window functions and derived datasets in SQL Server. I came across a query in a workload that was looking to get the most recent thing per group, a representative example in the Stack Overflow 2010 Database is below. The database is provided…
-
Curse of the Catch-All query
The catch-all query – a fairly common pattern that is often seen in SQL Server apps where there is a list of results that can be filtered by one or more criteria. This usually takes the form of a stored procedure that is constructed as below. The example stored procedure is created in the Stack…
-
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…
-
SQL Server – Working Smarter, Not Harder (Again)
In the last post we talked about the concept of creative laziness and how SQL Server’s query optimizer notices when the user has asked for something that requires no actual work due to a logical contradiction. In this post, we’ll look at another example of where the optimizer works smarter not harder and can reduce…
-
SQL Server – Working Smarter, Not Harder
Back in my university days, a lecturer of mine would say how programmers are experts in “creative laziness” He was referring to practices such as using methods and classes in C# – constructs that mean as a developer, you follow the DRY (Don’t Repeat Yourself) ethos – you are saving yourself time by writing things…
-
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…
-
More on Execution Plans
In my previous post on execution plans we looked at what an execution plan is, how SQL Server creates them and why we might use them, now we’ll delve a little further. Recap We very briefly compared two SQL Server execution plans on two queries against the Stack Overflow 2010 database provided under cc-by-sa 4.0…