Different Index Build Strategies For SQL Server

Link Up

This post is links to a series of articles that it’s a shame more people haven’t seen, because they describe why some index builds/rebuilds take a lot longer than others.

• Index Build strategy in SQL Server – Introduction (I)
• Index Build strategy in SQL Server – Introduction (II)
• Index Build strategy in SQL Server – Part 1: offline, serial, no partitioning
• Index Build strategy in SQL Server – Part 2: Offline, Parallel, No Partitioning
• Index Build strategy in SQL Server – Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))
• Index Build strategy in SQL Server – Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)
• Index Build strategy in SQL Server – Part 3: Offline Serial/Parallel Partitioning
• Index Build strategy in SQL Server – Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
• Index Build strategy in SQL Server – Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

Hopefully Microsoft doesn’t black hole these, as they have so much other valuable material recently.

Thanks for reading!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.