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.
2024-05-08
Filtered Indexes
Introduction to SQL Server Filtered Indexes
SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they be used? When are they most effective, and what sort of performance gain or space-saving is likely? How does a filtered index affect the choice of execution plan? Seth Delconte explores these questions with practical experiments.
2013-05-06
4,926 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
How are statistics stored?
Comments posted to this topic are about the item How are statistics stored?
Where's the Printer Friendly Option?
Comments posted to this topic are about the item Where's the Printer Friendly Option?
Switch from MSSQL SVC to MSA - Unable to start services
Using MSSQL 2019 standard edition It was installed using SVC Account. But now I...
Question of the Day
How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers