SQLpassion BLOG

A ever-increasing Clustered Key value doesn’t scale!

You know all the best practices how to choose a Clustered Key value? A good Clustered Key value should have the following 3 properties: Narrow Static Ever Increasing Let’s have a more detailed look on all 3 properties, and why an ever increasing value doesn’t really scale in SQL Server. Narrow A Clustered Key value …

A ever-increasing Clustered Key value doesn’t scale! + read more

Improving Query Performance by using correct Search Arguments

In today’s blog posting I want to talk about a very specific performance problem related to indexing in SQL Server. The Problem Imagine the following simple query, which you have already seen hundreds of times in your SQL Server life: — Results in an Index Scan SELECT * FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2005 AND …

Improving Query Performance by using correct Search Arguments + read more