Jeremiah Peschka

Jeremiah Peschka's ruminations on sql, ruby, c#, and other things
Skip to content
  • Home
  • About Me
    • Getting In Touch
  • Upcoming Events
    • Upcoming Training
  • Resources
    • Dynamic T-SQL Resources
    • Indexes & Performance Boosts
    • SQL Server Internals
    • Taking Control of Your Career

Top Tags

  • AppDev 26
  • awesome 37
  • community 35
  • dynamic sql 16
  • goats 17
  • hackery 15
  • omgponies 24
  • presenting 30
  • SQL 116
  • SQL Server 120
  • sqlpass 61
  • All Tags 170

SQL Server Internals

SQL Server Internals slide deck

Online Resources

The SQL Server Cost Based Optimizer – All about the CBO

Anatomy of a Record – How rows are stored on disk

Troubleshooting Performance Problems in SQL Server 2005 – A thorough white paper about troubleshooting performance and internals – still a valid document today.

SQL Server 2005 Waits and Queues

Books

Microsoft SQL Server 2008 Internals (Pro – Developer)

Professional SQL Server 2008 Internals and Troubleshooting

SQL Server 2005 Practical Troubleshooting: The Database Engine

©2010 Jeremiah Peschka. All rights reserved. RSS feed. This site uses the Basic Maths theme for WordPress, designed by Khoi Vinh & Allan Cole.