damons (4/28/2010)

---

So, from my perspective, the lack of service packs is to me a sign of a good solid code base (assuming that the urgent and critical bug reports are...

Chad Crawford (4/28/2010)

---

This was quite a surprise to me. I would have expected the Date and Datetime to have worked the same way, but I guess that's why...

TravisDBA (4/28/2010)

---

If you have ever looked at the massive FIX list of some of these SP's I think many will come to the conclusion that the SP's are not merely...

Mostly a good question. I got it wrong, because I was too hasty - I overlooked that the data type was DATE, not DATETIME (probably because I still work with...

Hi Steve,

I'm sure you won't be surprised a bit about my comments 😀

it is intended to correct only the problems that are described in this article. Apply it only to...

Paul White NZ (4/24/2010)

---

I believe Hugo is confusing the logging behaviour of TRUNCATE TABLE with the behaviour of minimally-logged data changes under the BULK_LOGGED recovery model.

The allocation unit deallocations performed...

Brandie Tarvin (4/23/2010)

---

SwaroopRaj (4/23/2010)

---

Truncates are *minimally logged* (EDIT: in ALL database Recovery models), like having your database in Bulk-Logged Recovery Model. That means there are pointers to the pages of...

Tom.Thomson (4/23/2010)

---

and I was very surprised to see that TPTB had decided to make it worth 6 points, because it is not at all an SQLServer question - although some...

I got it right, but I don't like the question.

The QotD should be about testing our knowledge of SQL Server. Not testing our ability to use a search engine. And...

terrance.steadman (4/22/2010)

---

Tao Klerks (4/22/2010)

---

To be fair, even if you saw the "Possible Error" in the INSERT (if you didn't know this was a SQL 2008 feature, like me) or if...

Ian Elliott (4/22/2010)

---

I don't think it's hard to write the perfect question if it's just given a little though on the basics e.g. test the question and answers on different...

Open Minded (4/22/2010)

---

I also learned something today. For the 1st time, I made the mistake of pressing enter after a single letter 's' in Sql Server 2005.

The 's' was...

vk-kirov (4/22/2010)

---

Hugo Kornelis (4/20/2010)

---

If SQL Server had an auto-tune feature that automatically adds indexes it beliefs will benefit performance, than you would be right. But no current version of SQL...

Good question. Not sure why it's worth 2 points; knowing that TRUNCATE can be rolled back should be elementary knowledge.

Abrar Ahmad_ (4/22/2010)

---

[font="Verdana"]Goodish, easy hunt. but for the only SQL Server...

I never understand that habit. The semicolon is a statement terminator, not a...