Looks like they took down the letter, http://blog.mandriva.com/en/2007/10/31/an-open-letter-to-steve-ballmer/ just gives me a "Not found" now. I wonder if Google cached it... 🙂

Ha, sorry, this was supposed to go in the beer cooler thread. Guess I've had too much already today.

ISNULL(p.TrackingNumber,'') > ''

...may be wasteful in terms of processor cycles, but it makes it a bit clearer that the author was at least deliberately thinking about the NULL case. That...

I think it should be noted that the "hop" problem pops up not just between instances of SQL Server...it can happen anywhere that credentials need to be delegated between "things"....

I don't know about 2008, but I'll speak to SQL Server 2005 and maybe someone can talk about 2008 specifically.

If it were me and my laptop could handle it (disk...

If you make the file a comma-delimited file and give it a ".CSV" extension then Excel should be able to open it up just fine. Just make sure you quote-delimit...

bill.windle (7/30/2009)

---

How would you create the SP for using DelimitedFileWriter and choosing pipes | ?

I see where in the Example files where you create the different procedures but if I...

OK, well, if you're coding in C# and you're not using "using" when instantiating your connection object(s) or you're not explicitly calling "dispose()" on the connection objects then you might...

Yes, I know. I was quoting you to agree and to ask the OP to post some source code. Sorry for the confusion.

🙂

This. I don't think a deadlock would...

One benefit to using stored procedures is that as long as your interface remains the same (that is, the parameters to the stored procedure), you can change the stored procedure...

mhli (2/21/2011)

---

Dennis Wagner-347763 (2/21/2011)

---

WTFs/minute sounds like a good measurement. Exceptional code can be measured in days between WTFs, really good code can be measured in WTFs/hour and really poor...

I tend to agree. I think the SQLCLR is a red herring, or at least is a minor contributor to what the problem really is. Can you post the code...

Any chance you could post some code?

Any chance you could post some code? Are you sure you're properly releasing resources that you're referencing in your code? It sounds like maybe you're not (and you're using DataSets...