Yeah, I'm not familiar with that table, but login with DAC and see what you can do that way.

You are right that you'll want to keep the old backup until the new one is finished. So to that end, you'll just size based off of that. ...

Yeah, I've done this many times, and scripting it is not only fairly easy, it's proven. Just script the backup, then script the copy, then the restore. take...

Do you get an error message when you try to delete?

I'm assuming so since you're trying to modify a system table.

You can modify system tables in Yukon if...

This can be done, but it's tricky. I would stage the parent data in its own table first, and then do a join to update the child table. ...

Have you tried looking at your perfmon counters to see where your bottleneck might be? That's always the first place to start.

Y, dude, you can't really mess with system tables.

Unless you have some kind of government directive that the data has to actually be housed on separate servers, you're not going to gain anything from using different instances. ...

I've been running the new Diskeeper on my lab SQL box for a couple months now and it's been very stable. And I'm pushing thousands of transactions against it...

Yeah, that shows the distribution of the stats on that index. I don't know why someone would be running that as much as you're reporting though.

You won't have that problem with log backups because they truncate the log. There are 2 ways to keep your log trimmed.

1. Use simple mode. ...

Isolation can help, but you can also cause more problems by putting that stress in tempdb. So just be careful with it because unless you've designed for it, you...

You'll have to export the data and put it in HTML format. In the case of the log, you could pretty easily export it out via SSIS and then...

Yeah, in order to have selects blaze through your update statements, you need to either use with (nolock), or with (readpast). If you're running several of these updates at...

Well, I don't think there's any way to do a metadata refresh except by hand in the GUI.

At this point I would say you've got 2 options:

1. ...