Index Defrag Script v3.0
Get free performance by defragmenting your indexes. Michelle shows you how.
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
Planning for Third-Party Applications
Mike Walsh talks about questions to ask before deploying a SQL Server based app.
Very Large Databases (VLDBs)
Notes from Brent Ozar's webcast on things to know when managing these databases.
SQL Server Tips Tutorial
Michelle Ufford's favorite tips and tricks for SQL Server Management Studio.
SQLIO Performance Measurement
Find out how fast your SAN really is with this free tool from Microsoft.
Killing Sessions with SSIS
Chris Webb shows how to use SSIS to take care of out-of-control queries.
More Wiki Articles...Blog Updates
Interview Questions to Ask a Company
Before you take a new job, find out what questions to ask during the interview.
Copying Jobs Between SQL Servers
Attach a restored msdb database with a new name and use this script to copy jobs from one server to another.
IntelliSense and Logon Triggers
Logon triggers can be fired when using SQL Server Management Studio 2008 with IntelliSense.