SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Filtered Indexes Rss

Search for any content tagged filtered indexes

   Items 1 to 5 of 5   

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem  Read more...
By Mike Good 2015/08/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,703 reads

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.  Read more...
By Additional Articles 2013/05/06 | Source: SimpleTalk | Category: filtered indexes
Rating: (not yet rated)  Rate this |   Briefcase | 4,790 reads

Filtered Indexes - Simple Partitioning without Enterprise Edition?

This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition  Read more...
By Nigel Maneffa 2013/02/21 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,183 reads

Exploring SQL Server 2008’s Filtered Indexes

One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.  Read more...
By Steve Jones 2009/04/06 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,667 reads

Filtered Indexes in SQL Server 2008

This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008  Read more...
By Additional Articles 2008/10/22 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,583 reads
   Items 1 to 5 of 5