Performance Tuning Formula 1 Style
Watch a free video of Brent Ozar presenting at SQLBits.
We're a wiki, like Wikipedia:
all of the information you see here is freely editable by any logged-in user.
Anyone can contribute to articles, add new code, edit articles, you name it. This site is by the community, for the community. Changes are moderated by our Editors, a group of SQL Server database professionals with a decade or more of experience in their field.
Wiki Updates
Collaboration of the Month: Wait Types
Read how to help other DBAs learn performance tuning.
Restoring User Databases to Different Environments
Need to restore production dbs over to development servers? Colin Stasiuk can help.
How to Use SP_Configure
Mike Walsh explains the basics of this frequently used stored procedure.
Getting the Last Clean DBCC CHECKDB Date
Sankar Reddy shows how to tell when your databases were last checked.
Index Selectivity and Column Order
Gail Shaw talks about picking which field goes first in an index.
More Wiki Articles...Blog Updates
T-SQL or SSMS - Same Thing Right?
Learn why SQL Server reacts differently when you use the GUI.
Rebooting a Server with PowerShell
Simple two-line command in PowerShell to restart a server.
Filtered Index Workaround
Learn why SQL Server may not be using the index you want.