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

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

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

usp_IndexesUnused - SQL 2k5

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

SQL 2005 IndexDefrag solution

Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night  Read more...
By Kobus 2008/06/19 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 952 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,973 reads

usp_IndexCreationStatements

(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.  Read more...
By Pedro Lopes 2007/12/13 | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 597 reads

2005 Online Index Rebuild using DMV

Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.  Read more...
By Tommy Bollhofer 2007/12/11 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 1,754 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,391 reads

Featured Blog: What happens to non-clustered indexes when the table structure is changed?

Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema.  Read more...
By Additional Articles 2007/10/31 | Source: SQLskills | Category: SQL Server 2005
Rating: (not yet rated)  Rate this |  Briefcase | 2,479 reads
   Items 1 to 7 of 7   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use