Category: Performance Tuning
SQL Server Memory Usage Grows and Not Shrinks
How to disable database mirroring for a particular database?
Why can't I install multiple instances of SQL Server Integration Services components on the same physical server?
What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the Transaction log?
SQL Server Management Studio takes a long time to load, how to improve the load performance of this tool?
When using SQL Server Management Studio Express I get the error "SQL Server does not allow remote connections". How to resolve this error?
Which edition of SQL Server 2005 is better, the Standard Edition or the Enterprise Edition?
Managing SQL Server 2005 Express installation & FAQ.
Performance delay when a full-text query is executed on a SQL Server with no connection to Internet.