http://www.sqlservercentral.com/Content tagged SQL Server 2005, Indexing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.http://www.sqlservercentral.com/articles/Indexing/63533/2008/07/22http://www.sqlservercentral.com/articles/Indexing/63533/This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/2008/07/09http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at nighthttp://www.sqlservercentral.com/scripts/Indexing/63036/2008/06/19http://www.sqlservercentral.com/scripts/Indexing/63036/http://www.sqlservercentral.com/questions/SQL+Server+2005/62226/2008/03/07http://www.sqlservercentral.com/questions/SQL+Server+2005/62226/Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database. http://www.sqlservercentral.com/articles/Indexing/2760/2007/12/13http://www.sqlservercentral.com/articles/Indexing/2760/Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.http://www.sqlservercentral.com/redirect/articles/61605/2007/12/04http://www.sqlservercentral.com/redirect/articles/61605/Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database. http://www.sqlservercentral.com/articles/Indexing/2760/2007/12/13http://www.sqlservercentral.com/articles/Indexing/2760/