home | the book | the author | error log | q&a | cool stuff | recommended reading | feedback form
Companion Site for Inside SQL Server 2005
Updated: 3 June 2008
Scripts from: The Storage Engine
Scripts from: Query Tuning and Optimization
You can download the History of SQL Server Chapter from my Inside SQL Server 2000 book.
Here are the scripts to build a pubs and a Northwind database:
Download pubs and Northwind Sample Databases
The Query Tuning and Optimization book uses a modified Northwind database called Northwind2
Download Northwind2 Sample Database
Chapter 1 in the Storage Engine mentions a whitepaper by Ron Talmage that discusses the SQL Server 2005 tools. It turns out that the whitepaper I was referring to was never updated after a very early beta and it is not applicable to the final version of the SQL Server 2005 product. However, you can download a whitepaper by Ron Talmage which describes using the TSQL Query Editing tools, and an article for SQL Server Magazine written by Ron and me that deals with more of the SQL Server 2005 tools suite.
Editing Transact-SQL Code in SQL Server 2005
SQL Server 2005 Management Tools
Here are the scripts and code snippets from
Inside SQL Server 2005: The Storage Engine:
Please note that the comments within the files are not intended to provide a complete explanation of the purpose of the code and the interpretation of the results. The comments for each code snippet are a line or two of text from the book and are included to allow you to match the code snippet with the location in the book that the code is copied from. The code is intended to be used in conjunction with the book.
Chapter 1: Installation and Upgrade – NO SCRIPTS
Chapter 4: Databases and Database Files
Chapter 5: Logging and Recovery
Chapter 7: Index Internals and Management
Scripts to build and populate partitioned tables (2 MB)
Scripts to estimate table and index space requirements
Chapter 8: Locking and Concurrency
All files from The Storage Engine (except scripts for partitioned tables, due to size)
Here are the scripts and code snippets from
Inside SQL Server: Query Tuning and Optimization:
Please note that the comments within the files are not intended to provide a complete explanation of the purpose of the code and the interpretation of the results. The comments for each code snippet are a line or two of text from the book and are included to allow you to match the code snippet with the location in the book that the code is copied from. The code is intended to be used in conjunction with the book.
The last paragraph of Chapter 1 talks about a tool to be released after the book’s publication that polls some of the system DMVs to build a performance warehouse. The tool was released shortly after the book went to the printers, so I link to it from my blog. The tool is called DMVStats and you can download it directly from here.
Chapter 4: Troubleshooting Query Performance
Chapter 5: Plan Caching and Recompilation
Chapter 6: Concurrency Problems
All files from Query Tuning and Optimization