Hugo Kornelis (6/27/2012)

---

Sorry for my lack of replies. I am currently attending the TechEd Europe conference in Amsterdam, so I have very little time for other stuff.

I don't have time...

Hugo Kornelis (6/25/2012)

---

When I answered the question, I *knew* I was taking a gamble on the intended interpretation.

What convinced me to pick the "wrong" answer was the wording: "can have...

Lynn Pettis (7/19/2012)

---

Good question. I over thought and picked the wrong answer. Yes, you can restore the database from any of the snapshots, you just have to delete...

Well, i think this should have been a multiple choise question.

I use it to:

- learn something new

- judge my skills

- gain some points to brag about

Jostein Saethern (11/27/2011)

---

The question is not really about datetime precision, but string comparison.

If the comparison value had been declared as datetime, then the other values would be implicitly converted to...

Happy Thanksgiving and ejoy your holiday, you deserve it!

charlietuna (10/23/2011)

---

The solution seems a bit opaque. Something like this is (to me) much more straightforward for the next person who has to read it:

update #t

set col1 = case col1...

CELKO (10/23/2011)

---

UPDATE Table1

SET col1 = -(col1 - 1);

Why make it so insanely complex? Here is a good programming exercise. Given table with {-1, 0, +1} ...

codebyo (9/17/2011)

---

I'd love to see an article showing a real world application of switching partitions.

I understand it would be great for historical data that can be archived by a date...

I've been working with SQL server since 1995, but never heard of Buck Woody. I think the explanation should give some references to the celebrities and not an accusation.

On...

Thanks for the excellent question, I really had to think.

#4 was obvious due to the SELECT *, but It took a while before I realized that you need a TOP...

chris.mcgowan (8/15/2011)

---

ANSI_PADDING should also be a correct answer!

Below from BOL;

In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option...

You are absolutely right. That was the point I was trying to Make with hakan.winther.

For me any post here is about the QOTD etc...

Anyone that thinks anything else is...

SanDroid (8/11/2011)

---

hakan.winther (8/11/2011)

---

SanDroid (8/10/2011)

---

hakan.winther (8/10/2011)

---

SanDroid (8/10/2011)

---

As would I if the error in the script did not cause the wrong result.

It seems incorrect to...

I thought that the backup would complete successfully, regardless of the transaction. It could have been a nice feature to be able to :

- start a transaction

- do some changes...