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

Content with tag online Rss

   Items 1 to 3 of 3   
 

Rebuilding SQL Server indexes using the ONLINE option

As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.  Read more...
By Additional Articles 2012/02/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,526 reads

Populate partition

Fill a specified partition of a table with a specific query, working on staging table   Read more...
By Federico Iori 2010/03/25 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 698 reads

Rebuild partition

Rebuilds online a table partition with all indexes   Read more...
By Federico Iori 2010/03/12 | Source: SQLServerCentral.com | Category: rebuild
Rating: |  Discuss |   Briefcase | 1,659 reads
   Items 1 to 3 of 3   
 
Tags
data warehousing (2)    
partition (2)    
defragmentation (1)    
etl (1)    
indexing (1)    
parallel (1)    
populate (1)    
rebuild (1)    
very large table (1)