Well, we don't use VS 2012 yet and I've not tried this with VS 2012, but I'll give it a shot.

1) Get Sql Server Data Tools! Download and install the...

Any chance you can upgrade to Visual Studio 2010 or later? SQL Server Data Tools, which is available in 2010/2012 is pretty darn useful, and it makes database development much...

I find it interesting that nobody has mentioned that building software, and modifying it, has an associated cost -- somebody has to pay for it.

When users ask for modifications to...

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...