This archive file contains the source code for examples in Professional SQL Server 2008 Internals and Troubleshooting (ISBN: 978-0470484289). The source code is for educational purposes only. The source code is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. The code is organized into folders corresponding to a chapter in the book. 1. Chapter 1 -- No scripts 2. Chapter 2 -- How much VAS script 3. Chapter 3 -- No scripts 4. Chapter 4 -- No scripts 5. Chapter 5 -- No scripts 6. Chapter 6 -- Locking, versioning and isolation levels 7. Chapter 7 -- Tempdb allocation contention, object re-use and space troubleshooting 8. Chapter 8 -- No scripts 9. Chapter 9 -- No scripts 10. Chapter 10 -- SQL Trace 11. Chapter 11 -- No scripts 11. Chapter 12 -- Plan compare 11. Chapter 13 -- SQL Nexus demo database and workload script 11. Chapter 14 -- No scripts 11. Chapter 15 -- No scripts 11. Chapter 16 -- IO Latency, SQl Server waits, and customized PerfStats files Corrections and improvements to the code samples are very welcome. Please send all comments to the lead author at christian@coeo.com