• I'd like more questions like this. One of the biggest technical leaps I made as a DBA was reading the "Inside" book series & learning HOW sql server does it's storage magic. It really helped me think better about the impact of my designs and queries, even for simple things like why using appropriate datatypes will/may results in fewer pages, and why this matters when saving & querying.

    It's a big topic, but it's something I think is really helpful to know.

    These types of questions are a great refresher to me on the calculations and thought process, and I think it will help others understand the guts of sql better.