SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Content with tags Administration, Index Management Rss

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

SQL Server 2005 (2)     DMVs (1)    
Backup / Restore (1)     Maintenance and Management (1)    
   Items 1 to 3 of 3   
 

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...
By Ola Hallengren 2008/04/15 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 2,888 reads

2005 unused indexes

Shows unused indexes compared to nr of modifications  Read more...
By Wilfred van Dijk 2007/12/18 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,244 reads

Index related DMVs and DMFs - sys.dm_db_index_usage_stats

Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats  Read more...
By Additional Articles 2007/11/12 | Source: SQL Server Performance | Category: SQL Server 2005
Rating: (not yet rated)  Rate this |  Briefcase | 1,235 reads
   Items 1 to 3 of 3   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use