Good question, thanks, always nice to pick up a new tidbit about 2012.

Good, easy question.

Thanks

Good question, but I would question if a method is reliable if it does not work less than 1/3 of the time daily, method 2 overloaded at 8 am since...

Good question although the unlustered index thing got me as well.

Good question, would have been nice if the answers were correct, read the first answer and chose it, not paying attention to the real answer #1, my bad. Didn't notice...

When I change the size for @str4 from 45 to 50 and ran a print LEN(@str4) I got a 48 not 49, which is the number of characters I count...

You missed the parenthesis surrounding the (@str1)

Good question, got it right but for the wrong, did some research and now know more about XML and SQL, Thanks.

An iffy question at best. I guess I'm glad we don't mess around with snapshots just full backups with twice nightly test restores.

Nice question, straight forward.

It did make me think seriously about getting a 2012 instance installed in a development/learning mode.

Good question, thanks.

I'll add my vote for 10.

Definitely a gotcha!

Another day, another incorrect answer, oh well. Alot of great posts though.