Articles

Page 6 of 10 — showing articles 91 to 108 of 177

Read Committed Snapshot Isolation

RCSI

The detailed behaviour of RCSI compared with locking read committed isolation, including subtle aspects to be aware of.

The Repeatable Read Isolation Level

Repeatable

The guarantees provided by the repeatable read isolation level, including some allowed behaviours you might find surprising.

Statistics on Indexed Views

Nice View

Multiple reasons to prefer using the NOEXPAND hint on indexed views, even on Enterprise Edition.

Nested Loops Prefetching

Prefetched Knowledge

SQL Server nested loops join internals including ordered and unordered delayed prefetching and undocumented trace flags.

Incorrect Results with Merge Join

Descending

A detailed analysis of a SQL Server optimizer bug that causes incorrect results when a descending non-unique index exists on a partitioned table.

Two Partitioning Peculiarities

Peculiar Partitions

Join and group by clauses may need to be written in a specific way to get the best results from the SQL Server query optimizer when using partitioning.

Aggregates and Partitioning

Aggregating and Partitioning

Improving performance for SQL Server MIN and MAX queries on partitioned tables and working around query optimizer limitations.