When I was at a SQLSaturday a few months ago, I attended a session that hit upon SQL Server Internals, one of my favorite topics. During the session the presenter was talking about page allocation, and mentioned that pages for a table and its indexes will reside in the same extents. Now, I remember immediately…
Continue Reading »
Last week I dialed into a customer site to make some changes to their database. The customer wanted to alter the configuration of the application, and the application interface did not permit the change they wanted. Neither the dial in nor the change request was unusual; what was unusual was that I had to ask…
Continue Reading »