http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx
Sample scripts and stored procedures for managing and working with SQL Server 2005.
Buffer Cache
Sample scripts and stored procedures for managing and monitoring the SQL Server buffer cache.
CPU and Optimization
Sample scripts and stored procedures for optimizing CPU performance in SQL Server.
Indexes and Indexing
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.
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
