• I bow my head in shame...

    As a DBA with 8 to 9 years experience, I flopped on the Page Fault question... In an interview, because I would have been thinking of physical pages on disk, not memory pages and swap files, I would have most likely given a similar, and just as faulty answer.  And worse, I would have thought that I was on the right track... I just looked up the Page Fault and realized that though I intuitively knew about the Page Fault problem (I ran into it when I was using Table Variables with very large table sizes) I never linked that name to it.

    To think, I've gone all this time in my career, from one small company to another, the only DBA guy in each company, so no one to turn to, teaching my self as I read from books to solve business questions and get my certifications, I hold a MCDBA in SQL 7.0 and SQL2000, and yet I didn't know something as basic as the Page Fault.

    Now I know that... But that doesn't relieve my guilt and shame. I mean, SQL is so big, and I know that there are thousands of other things out there that I still don't get. I feel like such a fraud. So, I was wondering, should I turn in my MCDBA's? And how do I go about doing that?