SQL Server Indexing – Columnstore Indexes
Learn all about columnstore indexes in our SQL Server indexing series. Join us to explore performance and key differences.
Indexing
Beneficial SQL Server Indexing tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.
Why use a Composite Index in SQL Server
Learn how a composite index SQL can reduce query costs and improve performance for multi-column queries in SQL Server.
SQL Server Indexing – Non Clustered Indexes
Learn about the non-clustered index and how it can enhance SQL Server performance in our indexing webinar.
SQL Server Indexing – Clustered Indexes
Join our session to learn about SQL clustered indexes and how they enhance performance in SQL Server indexing.
Move a SQL Server Table to a New Filegroup
Discover the steps to move a SQL Server table to a new filegroup, including handling clustered and non-clustered indexes.
Managing Underused Indexes in SQL Server Availability Groups – Part 2
Learn how to assess index usage in SQL Server across Availability Groups using comprehensive statistics to make better performance decisions.
Managing Underused Indexes in SQL Server Availability Groups – Part 1
Optimize your database performance by understanding SQL Server Availability Group index usage in both primary and secondary replicas.
Don’t rely solely on SQL Server’s missing index recommendations
Learn about SQL Server missing indexes suggestions and why you should look closer at the recommendations to further improve the index.
A Rolling Filtered Index in SQL Server
Learn how to create and maintain a rolling SQL Server filtered index to improve query performance and focus on the most current data.
SQL Index Rebuild vs Reorganize Comparison
This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.
Add Indexes to Improve SQL DELETE Performance
This article examines whether creating indexes can help when deleting data from a SQL Server table.
Prevent Duplicate Records in SQL using Filtered Index
In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table.
SQL Server Filtered Index Essentials Guide
Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.
Drop Index in SQL Server Examples
In this article, learn how to drop or disable a SQL Server index that is no longer needed. Also, learn how to recreate and script out indexes.
SQL Server Missing Index Recommendations: Do”s and Don”ts
Learn how to properly interpret these SQL Server index recommendations. Understand the pros and cons of SQL Server''s Missing Index Recommendations. While these recommendations are generated for individual queries, you''ll learn how to leverage their insights wisely to benefit your entire workload.
SQL Performance Degraded after Rebuilding Clustered Columnstore Index
In this article, we look at why SQL Server performance degraded after rebuilding a Clustered Columnstore Index and how to resolve it.
Rebuild Indexes in SQL Server Options and Potential Impacts
This article explains what happens to SQL Server queries when you rebuild an index offline and the differences for online rebuilds and index reorgs.
Improve SQL Server Query Performance for Clustered Index Seek
In this article, we look at how SQL Server indexes may be efficient for some queries but not others and steps to take to improve performance.
SQL Server Columnstore Indexes Tuple Mover Background Process
Learn about the tuple mover in SQL Server, what it is, and how it works to maintain SQL Server columnstore indexes in the background.
SQL Server Ordered Columnstore Indexes to Improve Data Warehouse Perfo
Learn what a SQL Server columnstore index is, when you would use one, and the option to order a columnstore index on one or more columns.
Filtered Indexes Ignored in SQL Server
Learn about SQL Server filtered indexes to improve performance, why SQL sometimes ignore these indexes, and what to do to make sure they are used.
SQL Server Filtered Indexes for Multi Table SQL Join Explained
Learn about filtered indexes and how to create in SQL Server as well as how to get a filtered index to work with data from multiple tables.
Covering Index in SQL Server with Key and Non-Key Columns
Learn how to build SQL Server indexes using key and non-key columns to create covering indexes that can help improve SQL Server performance.
Design SQL Server Indexes for Faster Query Performance
In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.