Nice post! Thanks!

Yeah, I've seen it before on reboot with a custom service I built many years ago that seemed to connect too quickly.

Is this a service? If so, try auto...

This should give you everything you need.

http://www.mssqltips.com/tip.asp?tip=1523

Please note under the Database Mail heading, there is another link provided in giving you step by step for configuring email for the alerts.

You can create a custom alert for any error #...

View the error in the log, write down the number. Go to Alerts and add it manually. You will...

A good example of what I have personally run into many times over the years.

SELECT * on a table where many columns are involved, but the code only needs 2...

This seems a bit too extreme and doesn't really stop programmers from using more fields than necessary not to mention slowing down your system.

Work close with your programmers, force them...

I dont know, you can think of a million different performance impacting ways to stop stupid from happening to your data. Yet, I think the best course of action...

da-zero (11/7/2010)

Absolutely true.

But I'm pretty confident this is not a disaster situation, but an...

I just did this a few days ago, but it may not be the route you want to go.

Basically, I just modified the data connection in visual studio. (database...

Under the server, security. right click the user account -> properties. Once the screen opens up for the user account, go to User Mapping. You can then...

So you have a specific code, then you want to see which items fall between a 7 day period for that code from the same table?

I'm not 100% on what...

Sorry, it's been a while.

So you are dealing with a million rows being inserted and this processor usage is after the fact? *the table in question is not locked and...

Never mind about what the transaction is doing. *forgot you described this above.

Still though, have you checked the performance monitor?

Also, what is your space reserved / space used of...

You said this happens after a large transaction? What is the large transaction actually doing?

If you're performing a mass update or delete to a large table, it could...

CASE WHEN TUploadTo.WCFComplete = 1 THEN 'WC' ELSE 'WI' END AS result