CptCrusty1 (8/24/2012)
--Advanced stuff that is rather obscure.
Just one point here... Unless your aim is to see if the person will make up garbage or admit they don't know, this probably should not be in an interview. Memorising obscure advanced stuff doesn't make someone a competent DBA and an interview should not be a trivial pursuit contest.
I mean, do you know the minimum and maximum sizes of a log block? If you do, when was that information last relevant?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability