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 4 of 4   
 

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,334 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,024 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,426 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,391 reads
   Items 1 to 4 of 4   
 
Tags
sql server 2008 (2)    
partitioning (1)