Over time I’ve accumulated a number of useful scripts and stored procedures. To help you out, I’ve bundled them up into a kit that I make freely available; after all, why duplicate someone else’s work?

sp_EnableDisableIndexes

A stored procedure which allows easy disabling and rebuilding of indexes on SQL Server tables, for the purposes of increasing performance on bulk operations.

sp_get_block_chain

A stored procedure that makes capturing and viewing block chain information a breeze.

sp_trace_helper

I don’t know about you, but I really hate clicking all those buttons in Profiler. This procedure makes setting up and reading data from traces really easy.

sp_balance_data_file

This makes calculating the ideal file size for SQL Server data files easy, and even gives you the commands to either grow or shrink (ugh, I hate that word) them.

Enter your e-mail address below and I’ll send you a link. I’m adding new ones and enhancing the existing ones all the time, so be sure to watch your inbox!