I have edited your post because it was too long and causing issues. I found > 67kb worth of a stored procedure.

No one is going to tune something that long....

Chris,

not saying you're completely wrong, but you're quoting journalists, who may or may not be correct. This whole thing is an opinion.

Loan guarantees are made all the time, on all...

Thanks for a great summary!

Chris,

not saying you're completely wrong, but you're quoting journalists, who may or may not be correct. This whole thing is an opinion.

Loan guarantees are made all the time, on all...

SP3 is being worked on, no dates yet, but the last guidance in June or July was that it would be out before 12/31/08

Please post in the appropriate forum. the names are at the top.

Moved to Report Development.

I've worked David's schedule, which is nice, every other Friday off, half staff each week.

I've worked 4 10s and those 10 hour days can be long, however it depends...

You can set performance counter alerts in Alerts to let you know things, but be careful. The CPU will jump to 100% often on a busy server, and that doesn't...

I've used views in both ways, though typically we've named them vXX, so that we know they're views. If you use one, you have to understand what's underneath. Typically I...

It's a self join. You may need information from two rows.

A simple example is an employee table that has a manager column. The manager column references the ID of another...

This help?

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31202/

Is this a char field? Can you use Substring to build something up?

I've got some land I can sell you as well.

Caveat Emptor

dgreatho, great points about us not knowing what to do. I think that's a problem, and don't know where we can go with that. Who should decide? Business wants to...

What do you mean by history? What information are you looking for? If it's code history, you should be using a version control system, and I know SQLCompare can compare...