Andy Warren (6/11/2014)
About the assumption, I'm not sure it was good to have in the answer, because the question had "You're the DBA with sysadmin access". But thinking beyond that, sometimes I want readers to infer things about the question. That makes it harder, more interesting, and less of a pure test taking skill question (maybe). Is infer better than assume? "This question depends on the reader correctly inferring..." vs "This question depends on the reader correctly assuming...". Reading those two, I think I do like infer better, as it does point toward derived knowledge and not just "I'm doing the SSC question of the day which means I'm an SA".
There's nothing in the question from which we can infer that, so we just have to assume it. It is of course a reasonable assumption, but on your past question track record you might well have thrown in the statement that we had sysadmin access as a red herring. 😛 Of course Of course maybe we don't have access to the particular instance other than sysadmin access, and assuming we have some other access would be a biiger assumption that assuming we were using the acess you told us we had, so it's the most sensible asssumption, and it's perfectly reasonable to have a question reqire us to choose the most sensible assumption - but see but clause in previous sentence. :w00t:
It's a nice question, anyway.