Grant Fritchey (1/6/2009)

---

GilaMonster (1/6/2009)

---

Which edition was...

There is a default trace running in SQL 2005. Doubt you can get what you want out of there, but it's your only hope. Well, that or invent...

Glad we could help. You're welcome.

You can have SSIS run .NET code, which can be used to automate Excel. Have SSIS create the Excel file, then a script opens the file through automation, auto-fits...

I've had plenty of instances where removing the time was important for a warehouse or reporting solution, but otherwise, I leave it in. I'd rather have it and not...

Try this, see if it does what you need:

SELECT a.application_id,

d.brandname,

dd.dosage,

...

The first thing I'd do is break the proc into smaller procs and have it all called from a master proc. Then you can tune each one.

As written, the...

I'm going to pretty much echo Gail on this one. If the column will be used in a Where or Join clause, put it in the key, but if...

I have a question about methodology. Why not, instead of OLE automation, use SSIS? It's designed to do this kind of thing. It has no problem whatsoever...

UDFs have to be followed by parentheses, even if they don't have input parameters.

Is your command:

set @_AsOfDate = dbo.svf_GetPriorMonthEndDate_asofdate

or is it:

set @_AsOfDate = dbo.svf_GetPriorMonthEndDate_asofdate()

If it doesn't have the parentheses, it...

A recursive CTE could find that for you. Use that with an If Exists check and roll back the transaction on violation.

I haven't worked for my current employer long enough to know whether it's great or merely good, but it sure looks promising.

The main thing I look for is morale. ...

Jeff Moden (1/6/2009)

---

Heh... "catch block"... that's another one... used properly, it's a great tool... but, for a huge number of the developers (using the term very loosly) I know, it's...

For that purpose, I wouldn't use dashboard reports at all. I'd run a trace, and analyze the CPU use, IO stats, etc., while filtering for that particular database. ...

Yes, I've been hired by a shadowy international group of conspirators. My job is to annoy people who suggest using cursors in SQL Server....