Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Filtered Indexes Rss

   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: | Category: indexing
Rating: |  Discuss |   Briefcase | 3,585 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,466 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: | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,132 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,461 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,430 reads
   Items 1 to 5 of 5   
sql server 2008 (2)    
database options (1)    
indexing (1)    
partitioning (1)