Page Free Space
SQL Server internals by Paul White
Showing posts with label
Partitioning
.
Show all posts
Showing posts with label
Partitioning
.
Show all posts
Wednesday 24 July 2013
Two Partitioning Peculiarities
›
Two Partitioning Peculiarities Table partitioning in SQL Server is essentially a way of making multiple physical tables...
Thursday 18 July 2013
Aggregates and Partitioning
›
Aggregates and Partitioning The changes in the internal representation of partitioned tables between SQL Server 2005 an...
Monday 17 June 2013
Improving Partitioned Table Join Performance
›
Improving Partitioned Table Join Performance The query optimizer does not always choose an optimal strategy when joinin...
Wednesday 12 September 2012
Why Doesn’t Partition Elimination Work?
›
Why Doesn’t Partition Elimination Work? Given a partitioned table and a simple SELECT query that compares the partitio...
›
Home
View web version