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.
Blog Updates
-
Performance Tuning Formula 1 Style
Watch a free video of Brent Ozar presenting at SQLBits.
-
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.