A few SQL Server script resources:
- SQL Server Best Practices
- Script Repository: SQL Server 2005
- Vyaskn’s SQL Server Site
- Backup, Integrity Check and Index Optimization
- SQLServerCentral Scripts
- Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005
- SQL Server Query Processing Team
- Common Solutions for T-SQL Problems
- SQL Server Programming Hacks
- Davide Mauri’s Index Scripts
- Seven Monitoring Scripts
- Five Very Useful Index Selection Queries for SQL Server 2005
Updated: added a few more.