Well, to get it to execute 10 times, just use this syntax:

EXEC myproc;

GO 10

As to how to gather the average of 10 executions... It depends on how you're capturing the...

Look up.

Sql Server Central...

It's possible your external IP address has changed? You shouldn't be sending people your internal IP address because it won't help them.

BTW, this is a SQL Server 2008 Forum. You...

Excellent! Looking forward to it.

It only goes back as far as the last time the server was restarted, but you can track schema changes through the built in report "Schema Changes History." I ran...

I'll pile on and suggest you have a Staging server that mirrors your Production environment (not necessarily in terms of memory & processing power, but certainly disk space) where you...

Holy cow, that's a ton of HUGE questions. Most of them can be answered, it depends.

To start with, it is possible to have too many relationships, but to determine if...

Copy db or a Restore should work. The restore would have to include renaming the physical files. It's easier to use TSQL, but if you want to use the GUI,...

I would have hoped for more of merge join than a loop...

Disk operations working the way they do, more spindles is better than fewer. That's at least part of why SAN's (properly configured, propertly maintained, etc.) succeed so well. I would...

Is it possible that you have cascade delete set up on the table? That might explain rows being deleted seemingly without action.

If you want to try to catch what's happening,...

You're trying to select multiple rows into a single variable. That just won't work. What about running that same XML query directly against the data rather than trying to move...

Now that I've taken the time to actually think about the answer to the question, yes, you'd need to recreate the script inside a monitor. Seems a bit odd to...

You're right. I don't know where I got that idea. Sorry about the bad information. I hate doing that. I shouldn't post based on vague notions.

I should have mentioned, VSDB is EXTREMELY expensive. It's a wonderful solution if you can get it, but most people are going to be happy with Red Gate or DBGhost.