Page Free Space
SQL Server internals by Paul White
Showing posts with label
Uniqueness
.
Show all posts
Showing posts with label
Uniqueness
.
Show all posts
Sunday 31 May 2020
Pulling Group By Above a Join
›
Pulling Group By Above a Join One of the transformations available to the SQL Server query optimizer is pulling a logic...
Thursday 4 April 2013
Optimizer Limitations with Filtered Indexes
›
Optimizer Limitations with Filtered Indexes One of the filtered index use cases mentioned in the product documentation ...
Friday 1 February 2013
A creative use of IGNORE_DUP_KEY
›
A creative use of IGNORE_DUP_KEY Let’s say you have a big table with a clustered primary key, and an application that i...
Thursday 4 August 2011
Avoiding Uniqueness for Performance
›
Avoiding Uniqueness for Performance In my last post, Enforcing Uniqueness for Performance , I showed how using a unique...
Friday 29 July 2011
Enforcing Uniqueness for Performance
›
Enforcing Uniqueness for Performance A little while back, I posted a short series on seeks and scans: When is a Seek ...
›
Home
View web version