mtassin (12/16/2010)

---

That would be...

Rune Bivrin (12/16/2010)

---

BOL doesn't say you'll get a "not defined error". It says the behaviour is undefined.

I got the column mismatch error same as everyone else when I tried...

I would say it really just depends on how well you type example, and...

The question clearly states "What will be the results of the following?". Not what does the Books Online say about nested temp tables using the same name.

Why is the answer...

Steve Jones - SSC Editor (12/15/2010)

---

However most people are hired because the person interviewing them a) likes them and b) doesn't know how to evaluate skills well.

We need to reverse...

jeff.mason (12/15/2010)

---

Boy does that question bring back memories. How many here have the scars of activity in 1998 and 1999 for Y2K? I bet any IT professional who...

Gopinath Srirangan (12/15/2010)

---

I apologize to all those who assumed all answers were wrong as time portion was missing.

As mentioned earlier, the objective of the question was to demonstrate century cutoffs...

Wow.... Let me start with this.

The company I currently work for has an 18 person IT Department consisting of 4 phone techs, 5 executives (including the CIO...

phil.wood 94423 (12/13/2010)

---

SanDroid (12/10/2010)

---

Most QOTD readers that actually run or test the QOTD scripts do so in a default NON...

Nils Gustav Stråbø (12/14/2010)

---

I would not expect much change in SGAM pages in...

TravisDBA (12/13/2010)

---

SanDroid (12/13/2010)

---

Fixing something that is broken requires skilled resources with real knowledge about developing a solution for an application issue. Removing it only requires removing the code...

Rahul,

We are not able to tell who these comments are for if...

Jeff Moden (12/11/2010)

---

MS should concentrate on doing more useful things.

.... Make any of the DBCC functionality more difficult to use? Heh... no way!

Leave these things alone....

This hole discussion reminds me of a time when I was asked to fix the custom log shipping scripts for a customer. The scripts stopped working sometime after it...

GilaMonster (12/10/2010)

---

If what you're trying to do is clean up too many VLFs, then you do (once and only once) want to shrink to 0 and then grow to the...