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, SQL Server 2005 Rss

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

Backup / Restore (1)    
DMVs (1)    
Maintenance and Management (1)    
   Items 1 to 3 of 3   
 

usp_IndexesUnused - SQL 2k5

Checks index usage  Read more...
By Pedro Lopes 2008/06/24 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 872 reads

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 | 4,329 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,337 reads
   Items 1 to 3 of 3   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use