Browse by Tags

Vote now: Index defragmentation best practices for SQL Server 2005 & 2008 documentation
26 February 08 10:25 AM | ssqa.net | with no comments

From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...

Filed under: sql server, best practices, index, vote now, defragmentation, connect

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 February 08 07:53 AM | ssqa.net | with no comments

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, 2005, server, performance, best practices, index, clustered, online, production

SQL Server 2005 Index Optimization Best Practices
19 February 08 07:04 AM | ssqa.net | 3 comment(s)

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with...

Filed under: sql server, ssqa, 2005, performance, best practices, reorganize, optimization, database, statistics, blogs, index, dbreindex, reindex