Here is a list of some of the most popular (and useful) free scripts and queries I’ve seen around the interweb. There are lot’s more and I’ll be adding them as I’m reminded of them.

---

Brent Ozar Unlimited

These guys seem to be putting out a script a week these days but they are still some of the highest quality and amazingly useful

• sp_Blitz A general health check of your instance.
• sp_BlitzIndex All you ever wanted to know about your indexes.
• sp_AskBrent Troubleshoot your slow server.

 

---

Adam Machanic

sp_WhoIsActive Want to know who working on your instance at the moment? This is it.

 

---

Midnight DBAs

Minion Reindex The Midnight DBAs have produced a reindex tool that appears to be second to none. Certainly the documentation is astonishing, particularly for a free tool. (They have even made noises that they may expand this into other areas so stay tuned.)

 

---

Ola Hallengren

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance Need a place to start? Or to finish for that matter. Here it is.

 

---

Paul Randal

Wait statistics, or please tell me where it hurts This is an awesome blog entry on wait stats with a great query to tell you what your instance is waiting on.

 

---

Dave Wentzel

Dave has a nice script for managing job history

 

---

Richie Rump

Statistics Parser This is a nice web based parser for the output of STATISTICS IO and STATISTICS TIME.

 

---

Paul Brewer

sp_RestoreScriptGenie This is a very nice restore script generator. There is a T-SQL version and a PoSH version.
Note: It pulls the data from msdb so may not work in a DR situation.

 

---

Me

Where is my backup? This is a good query to find out where your backups are going.

Looping through multiple servers in SSIS. I posted a three part loop through to create an SSIS package that can walk through multiple instances.

Creating a comma delimited list in a query. Technically this is about the STUFF function but it has a great pattern for creating a comma delimited string from a query.

Clean up your windows logins. The best method is in the comments.