Script Repository: SQL Server 2005

Script Repository: SQL Server 2005:
============================
http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true

• Buffer Cache

Sample scripts and stored procedures for managing and monitoring the SQL Server buffer cache.

http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true



• CPU and Optimization

http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true


Sample scripts and stored procedures for optimizing CPU performance in SQL Server.

• Indexes and Indexing

http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true

Sample scripts and stored procedures for working with SQL Server indexes.

• Input/Output

Sample scripts and stored procedures for managing and monitoring input and output in SQL Server.

• Performance (General)

Sample scripts and stored procedures for managing and monitoring general performance issue in SQL Server.

• Procedure Cache

Sample scripts and stored procedures for managing the SQL Server procedure cache.

• SQL Text

Sample scripts and stored procedures for working with SQL text.

• SQLOS

Sample scripts and stored procedures for working with the new SQL Server Operating System Layer.

• Tempdb

Sample scripts and stored procedures for working with the tempdb system database.

• Transactions and Logging

Sample scripts for working with SQL Server transactions and locks.

• Waitstats

Sample scripts and stored procedures for working with SQL Server waitstats.