Not sure what interviewer you are referring to but... what was the point of that comment? 😀 If I didn't see it on the exam then the exam is invalid??

Yes, I know a little about DBCC ShowContig. I teach both SQL Server 2005 and 2008 classes including IS, RS, AS, implementing, maintenance and Transact-SQL. (Yes I am aware of your credentials and their relative weight to my meager experience) But only a small percentage of what I cover is on the exams, mostly an in-depth understanding of the basics, but not necessarily every Transact-SQL statement on msdn, my point being you may have a pretty solid grasp on the basics but maybe not have heard of some statements. Probably not THAT one 🙂 but I am not totally surprised. How much experience should the MCITP exams test for? For someone with 10 years or so they have a DIFFERENT certification called Microsoft Certified Masters (as you probably well know). Maybe this is more in line with the level of knowledge that you expect from a mere MCITP... hehe... perhaps the MCITP is more highly rated than it deserves. It's not a Doctoral degree, just a certification that might make you an extra $5k a year or so at the right company. The MCM is a much more intense and thorough evaluation of your DBA skills and is meant for only the most serious data cowboys (they have MCM's for many different areas, too, right?). Maybe that is the one that might add value to your resume. That is... if you are up to it 😉 My guess is, with your background, you very well might be. I know I'm not.... yet.

Happy trials!!! (mispell intentional)