Indexing

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.

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.