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

Content with tags Indexing, SQL Server 2008 Rss

   Items 1 to 8 of 8   
 

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,567 reads

The FILL FACTOR

Will the FILLFACTOR Index option help to boost my database performance?  Read more...
By Brian Ellul 2010/12/16 | Source: SQLServerCentral.com | Category: fill factor
Rating: |  Discuss |   Briefcase | 10,912 reads

SQL Server 2008 Spatial Index Performance

The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?   Read more...
By Additional Articles 2010/04/08 | Source: MSSQLTips.com | Category: spatial data
Rating: (not yet rated)  Rate this |   Briefcase | 3,385 reads

Partitioned Table and Index Strategies Using SQL Server 2008

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.  Read more...
By Additional Articles 2009/07/10 | Source: TechNet Blogs | Category: partitioned tables
Rating:  Rate this |   Briefcase | 2,548 reads

Maximum No. of Indexes

By Sriram Yaddanapudi 2009/03/20 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,812 reads

Analyze and Fix Index Fragmentation in SQL Server 2008

This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation  Read more...
By Additional Articles 2008/12/11 | Source: SQL Server Performance | Category: fragmentation
Rating:  Rate this |   Briefcase | 2,476 reads

Index Seeks

By Site Owners 2008/02/21 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 3,190 reads

Featured Blog: SQL Server 2008: Partition-level lock escalation details and examples

Paul Randal of SQLskills takes a look at lock escalation in SQL Server 2008  Read more...
By Additional Articles 2008/01/30 | Source: SQLskills | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 1,326 reads
   Items 1 to 8 of 8   
 
Tags
fill factor (1)    
fragmentation (1)    
maintenance (1)    
partitioned tables (1)    
spatial data (1)    
sql server 2005 (1)