Indexing

Beneficial SQL Server Indexing tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
JSON Data Type and Indexes in SQL Server 2025 Daniel Calbimonte2026-06-11
Types of SQL Server Indexes Ben Snaidero2026-06-09
SQL Server Indexing – Columnstore Indexes MSSQL Tips2026-05-14
Don’t rely solely on SQL Server’s missing index recommendations Mehdi Ghapanvari2026-05-14
A Rolling Filtered Index in SQL Server Aaron Bertrand2026-05-09
SQL Server Indexing – Non Clustered Indexes MSSQL Tips2026-04-08
SQL Server Indexing – Clustered Indexes MSSQL Tips2026-03-25
Why use a Composite Index in SQL Server Deepak Vohra2026-03-20
Move a SQL Server Table to a New Filegroup Burt King2026-01-16
Managing Underused Indexes in SQL Server Availability Groups – Part 2 Aaron Bertrand2025-10-08
Managing Underused Indexes in SQL Server Availability Groups – Part 1 Aaron Bertrand2025-10-03
Retrieving SQL Server Index Properties with INDEXPROPERTY Greg Robidoux2025-05-21
SQL Server Index Tutorial Overview Ben Snaidero2025-05-01
SQL Server Clustered Indexes Ben Snaidero2025-05-01
SQL Server non-clustered Indexes Ben Snaidero2025-05-01
SQL Server Heap Ben Snaidero2025-05-01
SQL Server Columnstore Indexes Ben Snaidero2025-05-01
SQL Server Full Text Indexes Ben Snaidero2025-05-01
SQL Server XML Indexes Ben Snaidero2025-05-01
SQL Server Spatial Indexes Ben Snaidero2025-05-01
SQL Server Index Maintenance Ben Snaidero2025-05-01
More Index Information Ben Snaidero2025-05-01
Avoid Index Redundancy in SQL Server Tables MSSQL Tips2025-03-27
Update Statistics SQL Server Ben Snaidero2025-01-23
SQL Index Rebuild vs Reorganize Comparison Sergey Gigoyan2024-09-04
Add Indexes to Improve SQL DELETE Performance Jared Westover2024-06-26
Prevent Duplicate Records in SQL using Filtered Index Jared Westover2024-06-19
SQL Server Filtered Index Essentials Guide Simon Liew2024-04-03
Drop Index in SQL Server Examples Joe Gavin2024-03-28
SQL Server Missing Index Recommendations: Do”s and Don”ts MSSQL Tips2023-09-28
SQL Performance Degraded after Rebuilding Clustered Columnstore Index Mehdi Ghapanvari2023-09-12
Rebuild Indexes in SQL Server Options and Potential Impacts Jared Westover2023-08-28
Improve SQL Server Query Performance for Clustered Index Seek Mehdi Ghapanvari2023-08-16
SQL Server Columnstore Indexes Tuple Mover Background Process Jared Westover2023-08-14
SQL Server Ordered Columnstore Indexes to Improve Data Warehouse Perfo Jared Westover2023-06-19
Filtered Indexes Ignored in SQL Server Jared Westover2023-02-16
SQL Server Filtered Indexes for Multi Table SQL Join Explained Jared Westover2023-01-23
Covering Index in SQL Server with Key and Non-Key Columns Jared Westover2023-01-11
Design SQL Server Indexes for Faster Query Performance Jared Westover2022-10-20
Indexing in SQL Server with Clustered and Non-Clustered Indexes Jan Potgieter2022-10-12
Find All SQL Server Index Hints in Stored Procedures or Queries Aaron Bertrand2021-11-03
SQL Server Filtered Index Example Eric Blinn2021-08-10
INDEXPROPERTY Function in SQL Server Manvendra Singh2021-05-13
SQL Server GUID Column with Index Considerations and Identifcation Scripts Mohammed Moinudheen2020-10-15
SQL Server Index Basics Eric Blinn2020-05-14
SQL Server Index Analysis Script for All Indexes on All Tables Greg Robidoux2020-02-24
Building SQL Server Indexes in Ascending vs Descending Order Greg Robidoux2020-01-24
Faster SQL Server SELECT COUNT(*) Queries with Columnstore Indexes Aaron Bertrand2020-01-06
SQL Server Maintenance Plan Reorganize Index and Update Statistics Tasks Sergey Gigoyan2019-12-20
SQL Server Maintenance Plans Rebuild Index Task Sergey Gigoyan2019-12-13
How Forced Parameterization in SQL Server Affects Filtered Indexes Aaron Bertrand2019-09-19
SQL Server Clustered Tables vs Heap Tables Greg Robidoux2019-07-03
Collect SQL Server Index Usage for All Instances with PowerShell Alejandro Cobar2019-06-10
What is the Best Value for Fill Factor in SQL Server Eric Blinn2019-02-15
Script to Create and Update Missing SQL Server Columnstore Indexes Dinesh Asanka2018-10-26
SQL Server Clustered and Nonclustered Columnstore Index Example Jayendra Viswanathan2018-08-31
SQL Server Clustered Index Behavior Explained via Execution Plans Dinesh Asanka2018-08-28
Creating Indexes with SQL Server Management Studio Jayendra Viswanathan2018-08-20
Be Careful with Key Order in SQL Server Missing Index Recommendations Aaron Bertrand2018-07-17
Deeper insight into used and unused indexes for SQL Server Greg Robidoux2018-06-02
SQL Server Clustered Columnstore Index Examples for ETL Tim Smith2017-12-20
Safely Dropping Unused SQL Server Indexes Svetlana Golovko2017-12-07
Build a Robust Incremental SQL Server Update Statistics Procedure Jeffrey Yao2017-11-02
How to Overcome the SQL Server Filtered Index UnMatchedIndexes Issue Ahmad Yaseen2017-09-26
Supercharge your Data Warehouse with Columnstore Indexes – Webinar Q&A Koen Verbeeck2017-09-11
Script to identify all non-indexed foreign keys in a SQL Server database Eli Leiba2017-08-17
SQL Server 2016 Increased Non-Clustered Index Key Size Ahmad Yaseen2017-08-03
SQL Server 2016 ColumnStore Index String Predicate Pushdown Ahmad Yaseen2017-07-20
SQL Server Insert Performance for Clustered Indexes vs. Heap Tables Ben Snaidero2017-07-07
Script to Disable Non Used SQL Server Indexes Eli Leiba2017-03-27
Difference between SQL Server Unique Indexes and Unique Constraints Sergey Gigoyan2016-06-13
SQL Server Performance Tuning Tip – Index Foreign Key Columns Mike Eastland2016-05-26
SQL Server Columnstore, B-Tree and Hybrid Index Performance Comparison for Data Warehouses Fikrat Azizov2016-02-08
SQL Server Column Store Index Performance Ben Snaidero2015-09-01
Persisting SQL Server Index-Usage Statistics with MERGE Marios Philippopoulos2015-06-02
Identify SQL Server Indexes With Duplicate Columns Ben Snaidero2015-05-01
SQL Server Query Performance After Index Maintenance for Reorganization vs Rebuild Operations Ben Snaidero2015-03-03
SQL Server Covering Index Performance Fikrat Azizov2015-02-20
SQL Server Index Report with Included Columns, Storage and more for all Tables in a Database Percy Reyes2015-02-03
Script out all SQL Server Indexes in a Database using T-SQL Percy Reyes2014-12-18
SQL Server Index Properties in Management Studio Brady Upton2013-11-07
When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes Tim Wiseman2013-09-30
SQL Performance Issue for Single Row Delete or Update Operations Simon Liew2013-08-16
Querying SQL Server Index Statistics Dattatrey Sindol2013-06-21
SQL Server’s Auto Update Statistics Async option Tibor Nagy2013-03-12
Move all SQL Server indexed views to a new filegroup Aaron Bertrand2013-02-06
Index Create Memory Setting for SQL Server Manvendra Singh2012-12-05
SQL Server 2012 Column Store Index Example Arshad Ali2012-10-12
SQL Server Auto Update and Auto Create Statistics Options Tibor Nagy2012-09-13
What are the SQL Server _WA_Sys… statistics? Tibor Nagy2012-08-09
How to Find Outdated Statistics in SQL Server 2008 Tibor Nagy2012-08-03
SQL Server Index Column Order – Does it Matter Ben Snaidero2012-06-20
Columnstore index feature in SQL Server 2012 Rajendra Gupta2012-04-02
SQL Server Tables without a Clustered Index Jeremy Kadlec2011-10-04
Understanding and Examining the Uniquifier in SQL Server Ken Simmons2010-08-03
Using Hints To Test SQL Server Indexes Ken Simmons2010-06-24
Missing Index Feature of SQL Server 2008 Management Studio Ashish Kumar Mehta2010-02-18
Understanding SQL Server Index Fill Factor Setting Bru Medishetty2010-02-11
SQL Server Unique Constraints for Large Text Columns Sankar Reddy2009-10-28
SQL Server Indexing Basics Jeremy Kadlec2009-07-14
Retaining historical index usage statistics for SQL Server Part 3 of 3 Tim Ford2009-07-08
Disabling Indexes in SQL Server 2005 and SQL Server 2008 Ashish Kumar Mehta2009-07-07
SQL Server Filtered Indexes Arshad Ali2009-07-02
Retaining historical index usage statistics for SQL Server Part 2 of 3 Tim Ford2009-06-05
Retaining historical index usage statistics for SQL Server Part 1 of 3 Tim Ford2009-05-12
How to create indexes on computed columns in SQL Server Atif Shehzad2009-03-06
Finding a better candidate for your SQL Server clustered indexes Greg Robidoux2008-12-09
SQL Server Index Checklist Jeremy Kadlec2008-03-11
How can I get sysindexes information in Sql 2005? Chad Boyd2007-10-15
What indexes are used most often (or least often) on my server? Chad Boyd2007-10-15
Tracking index maintanence information Chad Boyd2007-10-15
Non Unique Clustered Index and Duplicate Value limits Chad Boyd2007-10-15
How to get index usage information in SQL Server Greg Robidoux2007-05-08
Index System Tables in SQL Server 2000 vs SQL Server 2005 Chad Boyd2007-03-29
Understanding SQL Server Indexing Greg Robidoux2007-03-22
Improve SQL Server Performance with Covering Index Enhancements MSSQL Tips2006-09-29
Index Builds in SQL Server 2000 vs SQL Server 2005 Jeremy Kadlec2006-09-07
SQL Server Max Degree of Parallelism for Index Creation and Rebuilding Jeremy Kadlec2006-07-27