Browse by Tags

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

SQL Server Lockdown - Step by Step procedure
13 February 08 11:06 AM | ssqa.net | with no comments

Cross posting from other blog - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/13/3502.aspx fyi. Hope you don't want to do it!

Filed under: blog, sql server, ssqa, security, best practices, lock down, availability