Florian Reischl (7/14/2009)

---

Thank god for good old C(++) and the possibility to create your own, verbose and friendly programming language:

#define Please if

#define Execute (

#define ...

The only thing that I can figure then is that dropping the Service must also be either deleting or updating the ~25M messages in the queue, which is why the...

Gianluca Sartori (7/14/2009)

---

RBarryYoung (7/14/2009)

---

Hmmm, should...

Grant Fritchey (7/14/2009)

---

I hate to pop everyone's bubble, but wasn't it established a while back that the 666 number is either a mistranslation or a bad copying job and tha...

Hmmm, should work?

GilaMonster (7/14/2009)

---

Dave Ballantyne (7/13/2009)

---

GilaMonster (7/13/2009)

I was referring to one of the other of his threads, the one that Dave posted.

SELECT <lots> FROM <somewhere> WHERE tatcalltype = 'null' AND <other conditions>

Done,...

TRUNCATE is a DDL operations and not a DML operation.

What do you get from "SELECT Count(*) From YourQueue"?

Paul White (7/13/2009)

---

Florian Reischl (7/13/2009)

---

VB6 is way back for me... As I remember "Nothing" was equivalent to "null" which only worked for complex data types (not Integer, String, ...). Working...

I second what Gus says, and I'll...

David Brusowankin (7/13/2009)

---

...

Thanks for your informative post. I saddens me that 10 years after Informix bought Illustra and merged their solution into that database platform, Microsoft still hasn't caught up....

I stand corrected... 🙂

I find that there are two common assumptions that developers make about SQL Server & CLR that lead to first, over-application of SQLCLR on SQL Server and secondly, to confusion...

David Brusowankin (7/13/2009)

---

I've been testing CLR performance using the SQL 2005 sample code provided by Microsoft and I find that it is slower that more standard solutions. I'll give 2...

That sure looks a lot better. 🙂