16 – Filtered Indexes (23m)

Most of the time, all you need is love nonclustered indexes. But every now and then, 3 scenarios pop up that require special handcrafted indexes. Here’s the first one: when your users passionately care about a very small percentage of rows, like 5% or less, and can’t afford the indexing overhead on the rest of the...