August 17, 2011 at 10:42 pm
Comments posted to this topic are about the item Auto Page Recovery with DB Mirroring
August 17, 2011 at 11:03 pm
Nice question.
There is a typo in the answers - "Page Free Spage" should be read as "Page Free Space".
August 18, 2011 at 12:03 am
Good question, Thanks.
M&M
August 18, 2011 at 12:46 am
This was removed by the editor as SPAM
August 18, 2011 at 2:24 am
Good question, good clear answer.
Rather a lot (60%) of people getting it wrong, surprisingly.
Tom
August 18, 2011 at 5:45 am
Excellent question. Learned something new today.
http://brittcluff.blogspot.com/
August 18, 2011 at 6:01 am
Tom.Thomson (8/18/2011)
...Rather a lot (60%) of people getting it wrong, surprisingly.
I'm surprised that more people didn't get it wrong - especially if, like me, they attempt to answer without looking it up. I wasn't at all surprised to get it wrong - it doesn't strike me as the kind of thing you just know or can work out. I made an educated guess and got one right.
John
August 18, 2011 at 6:26 am
*sob* I read the question backwards... that is, "Which types of pages can be auto recovered..." I remember thinkings, wow... there must be a whole lot that can't be auto-recovered. Index pages aren't a problem, and I know PFS and GAM aren't. Hmmm... well, logically which two would most critically need to be recovered.
Doh! >< I must read the questions closer before answering.
I have to assume the 12% of people who also answered "Data" MUST have read it the same way. (I will HAVE to choose to assume they read it that way...)
August 18, 2011 at 6:55 am
Thanks, good question
August 18, 2011 at 7:40 am
Nice question! Thanks!
August 18, 2011 at 7:54 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 18, 2011 at 9:41 am
Woot - nice question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2011 at 10:12 am
nice question!!
August 18, 2011 at 10:20 am
Great question. I am also a little suprised at the 60% wrong answers rate. Although I understand why some would have selected all of the Allocation Page types.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy