SQLWebpedia

SQL Blocking & Lock Info

• http://www.sommarskog.se/sqlutil/beta_lockinfo.html - Erland has created a great all in one script for SQL 2005 SP2 blocking information. He also has a different script for previous versions.

Partitioned Tables

• http://www.sqlwebpedia.com/content/partitioned-table-queries

SQL Backup and Maintenance

• Ultimate backup scripts by yours truely SQLGuyChuck. Can do just about anything with native or Litespeed backups.
• http://ola.hallengren.com - Ola created a backup script that includes reindexing.

Documenting and Source Control Scripts

• http://sourceforge.net/projects/script-sql-db/ - Script out your whole server, or just a db or table.

Other Sites with Good SQL Scripts

• SQL Server Examples website has some good scripts that you should check out. You do have to register to view, but should be worth it.
• SQL Server Community - Lots of user submitted scripts.

Microsoft Provided

• http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true - Script Center has lots of cool scripts. This link jumps you into SQL 2005 area.