ms_foreachtable might not work if you have FK relationships. I don't believe the RI will allow you to truncate the tables.

Nice trick for using Database Mail in SQL Server 2000. I must admit I was wondering how you were going to do this when reading the title.

Thanks, Carl. Good to have that handy.

SQL Saturdays have ranged from a low of 50-60 people to a high, I believe, of about 400. The more successful ones have been 300+, but space limitations sometimes restrict...

Congrats, Lynn.

Experience is nice, but it would be good to see some objective measurements on this. Not saying you're wrong, just would like it to be something other than a guess...

Jeffrey,

Do you have a 64 bit reference? I haven't seen this.

Even on 32-bit machines, with 2GB of RAM, I haven't seen SQL Server starve the OS. OS priority on memory...

Typically there are two places where i've seen this issue.

1. The plans were created on a version of SSMS that is different than the one you are using. This is...

It look like you have no limits on SQL Server memory, which is OK if this is a dedicated SQL Server machine.

you might want to read this blog (http://sqlblog.com/blogs/lara_rubbelke/archive/2008/04/18/memory-pressure-on-64-bit-sql-server-2005.aspx), which...

What is pagefile system? Do you mean the page file set on disk? what are the settings for that?

Please don't do that. It's rather rude and improper. If you need to ask a question, leave it here. Or edit it to explain better, but don't just remove it.

LOL, not me, though I might not be the easiest person to work with all the times. It's stories I hear, or things I've seen at it is work. It...

Also, on the nuclear issue, and even in some manufacturing plants, the code used in IT isn't something you're changing and deploying on a regular basis. Most IT that I've...

I think the point has been missed slightly. I'm not saying that you can't drink at lunch, or have a drink and come back to work for something. I'm noting...

I'm not sure about that. Some bosses...