Monthly Archives: November 2011

Page Allocation: Dedicated vs. Mixed Extents

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…

A Call for Volunteers

In the spring of 2010 I saw this post from Tim Edwards and immediately emailed him.  I was very new to the SQL Server Community at the time and I was looking for ways to get involved.  I thought the Performance Virtual Chapter would be a good fit, and I was right.  Tim selected me…

A Successful Failure

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…

Meme Monday: What #sqlfamily Means To Me

I have a lot of titles in my family.  I am a daughter, granddaughter, cousin, sister, wife, aunt and mom.  The roles that go along with the titles are different in each family.  Sure, there are many similarities, but every family has dysfunction (which is why you get some sons and daughters who do a…