SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts with tags Index Management, Maintenance Rss

Refine your search with one of the following additional tags (with number of items):

Automation (1)    
Fragmentation (1)    
T-SQL (1)    

Search for any content tagged Index Management & Maintenance

Add a script

   Items 1 to 2 of 2   
 

Check Fragmentation on All Indexes on Database

In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %   Read more...
By Augusto Alfonso 2008/09/03 | Source: SQLServerCentral.com | Category: Index Management
Rating: |  Discuss |  Briefcase | 68 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2008/01/08 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,215 reads
   Items 1 to 2 of 2