I typically use triggers for auditing, though that use is getting reduced or eliminated on SQL 2008.

You've left a lot of important information out.

32 bit? 64 bit?

What OS

What edition of SQL 2005?

How much memory does the server have?

No prob. I was just worried that someone...

Jonathan Kehayias (11/29/2008)

---

Gail,

The Visual Studio Express Editions don't include database projects in them, at least the last time I checked...

Hmm. That almost looks like the main plan's corrupted. Can you try recreating it? Can you also try backing up to that device not using the maint plan?

Hell, no! Plenty areas I don't know well (and that's...

Two more things.

Stored procedures should not be created with the sp_ name, That's for system procedures and means that SQL will look in one of the system databases first for...

TCP Chimney I don't know. May I suggest a google search?

As for CU9, providing you're on SP2 (which I assume you are), you can request the cumulative update from microsoft....

You're passing the value invoiceid to the procedure, but you're doing nothing with it within the procedure.

If you want to use the parameter to filter the query, it needs...

I'd guess there's no data for the period in 2008 within the invoices table.

Considering that a derived table in a query isn't usually executed in 2 steps (ie, the query processor doesn't...

I used to have some of mine in my sig. Not a laundry list. Just 2 or 3. I put them there after a bad experience (on another forum) where...

That bracket right after the begin that shouldn't be there.

Meaning 1 day later than the datemax that the user...

The rest looks good (other than the varchar types)

What do you want to do with the resultset...

Jeff Moden (11/28/2008)

---

Before folks get into what could be a heated debate, Table Variables, Temp Tables, and Derived Tables (sub queries in the FROM clause) all live in the same...