Learned something today.

Thanks!

Good question.

Thanks!

I actually thought "select distinct * ..." might raise an error.

I have never used this and wonder why it would even be allowed.

+1.

Thanks!

Hi guys.

I actually got it right since I knew from the answers which options I could definitely do with temp tables but I took my time before answering.

I've read...

Good question and the effort to explain all incorrect answers are very much appreciated.

Well, I haven't tried it in 2014 but CTRL+D works in 2008R2 so I went for it and got it right.

I got it wrong.

I'm still not sold on why the fragmentation would still be there.

This is a much better approach than comparing column by column.

Happy New Year, Everybody!

Hope you are all able to keep your resolutions; I'll try my best to complete mine. One of which is to be more active in the Sql...

paul.knibbs (11/8/2013)

---

I kind of agree with waxingsatirical...it never occurred to me anyone would think this works otherwise, and I spent a good few minutes trying to figure out what unexpected...

I find this one to be a very good question but one that can be easily answered by just analyzing the available options.

First, you need to select 4 correct answers...

Good one. I'm glad we finally have this function.

I'm surprised it took so long!

+1

I should have gone with this thought...