Paul White NZ (4/1/2010)

---

Hugo Kornelis (3/31/2010)

---

...I submitted a bug report... a case I constructed, based on this discussion, where COALESCE(..., 1) may erroneously return NULL (which should of course never...

I think that's him expressing himself...

Maybe, but the answer...

The...

Jeff Moden (3/30/2010)

---

blandry (3/30/2010)

---

I am tired of this debate and can only address it as I know it...

The best DBAs that I have seen, worked with, or had work for...

CirquedeSQLeil (4/6/2010)

---

Jeffrey Williams-493691 (4/6/2010)

---

CirquedeSQLeil (4/6/2010)

---

Paul White NZ (4/6/2010)

---

Probably will - though the definition of 'today' varies...;-)

Eight hours of 7^th April 2010...

john.arnott (4/6/2010)

---

You know, the first time I played with a computer was in 1966 (it was the Ferranti-Packard Orion II at...

Is that last Monday or next? You have to...

John Rowan (4/6/2010)

---

This was actually SS2000 EM and my meaning is that he was completely unaware of how to use the GUI to backup a database. Not that I'm...

Garadin (4/6/2010)

---

Tom.Thomson (4/6/2010)

---

Peter Brinkhaus (3/23/2010)

---

Note that variable names @, @@ or names starting with @@ are deprecated in SQL 2008. See http://msdn.microsoft.com/en-us/library/ms143729.aspx:

Do not use @ or @@ or names that...

Peter Brinkhaus (3/23/2010)

---

Note that variable names @, @@ or names starting with @@ are deprecated in SQL 2008. See http://msdn.microsoft.com/en-us/library/ms143729.aspx:

Do not use @ or @@ or names that begin with...

The Dixie Flatline (3/23/2010)

---

You don't have to reverse-engineer much to figure out that the code posted could never work.

DECLARE @DCMResourceID varchar(max)

Set @DCMResourceID ='2604, 2606,2607,2610'

WHILE (patindex('%,%', @DCMResourceID) > 0 )

begin

select (patindex('%,%',...

That will work...

Thanks for another good useful article.

Good question.

A bit worrying that 1% of replies so far suggested they were kept in tempdb, though.