Indexing in SQL Server with Clustered and Non-Clustered Indexes
In this article, we look at how to create clustered and nonclustered indexes for SQL Server tables.
Beneficial SQL Server Indexing tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.
In this article, we look at how to create clustered and nonclustered indexes for SQL Server tables.
In this article we look at a script you can use to find all index hints that are being used from the SQL Server cache and from stored procedure code.
Learn about filtered indexes in SQL Server with this example along with pros and cons and how SQL Server handles filtered indexes.
In this article we look at how to get various properties for SQL Server indexes and statistics for a specified table.

Learn the what, why, where, when of SQL Server statistics to get a better understanding how important statistics are for optimized query performance.
In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.
In this tip we provide an overview of SQL Server clustered and non-clustered indexes and some things you should know about creating and maintaining these types of indexes.
In this article we look at different use cases for columnstore indexes like when performing SQL Server count * queries.
Learn about SQL Server index types and how they can enhance your query performance and database efficiency.
In this tip we look at how to setup the reorganize index task and update statistics task in SQL Server Maintenance Plans.
In this article we look at how to create a SQL Server Maintenance Plan to rebuild indexes.
In this tip we look at how turning on Forced Parameterization for a SQL Server database can impact the usefulness of Filtered Indexes in that database.
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.
In this tip we look at a SQL Server script you can run to generate new columnstore indexes and also generate scripts to update existing columnstore indexes.
In this tip we look at how to create clustered and non-clustered columnstore indexes in SQL Server.
In this tip we look at different SQL Server queries to get an understanding of how the clustered index is used.
In this tip we do an overview of how to create indexes using SQL Server Management Studio.
This tutorial will try to go through each type of index available in SQL Server and explain why/when each one could be used to improve your query performance.
In this section we cover what a clustered index is, how to create and things you should know about clustered indexes.
In this section we cover SQL Server non-clustered indexes.
In this section we discuss what a table is called that does not have a clustered index.
In this section we will look at columnstore indexes and how these indexes can improve performance of your queries.
In this section we will take a look at the full text index feature of SQL Server and how to create and use these indexes.