Intereseting, I have friend running almost exclusively blades. Of course, that limits the size of the host, and then the VMs, but they have been happy with blades. I think...

From what I've read, the OP needs his old schema back, but needs to move data entered since rollout back to that schema. So moving good data out is what...

That's a reasonable strategy, and it's how people tend to deal with lots of inserts that might cause page splits.

Can you do sequential GUIDs in the remote locations? That might...

WayneS (10/15/2010)

I don't...

LOL, that's great!

I would have thought so, but if people entered data in a new system, you can't restore without losing that data. So you need to migrate backwards the data.

delete without a where clause.

Done it too many times to count.

Tend to agree with Gail, good indexes mean that 10mm rows shouldn't matter.

These are separate functions. Monitor could be a lot of stuff, and lots of tools. SQL Response (I work for REd GAte), Server's Alive, What's Up, multiple packages here. Depends...

Walked into a startup and they'd been making backups before all deployments to their mission critical database for their product. They were having a crisis and couldn't restore the db.

Watching...

Luke has great advice. This isn't a Reporting Services issue, it's a permissions issue in the database that holds this data.

You could potentially use a second fact table, but is that easier to query? I mean you'll have multiple rows of the same data there.

I think having Paul's advice works,...

You could use Red Gate's Data Compare as well, but what you're talking about is a custom job. There's no easy way for a tool to make the decisions about...

Don't use network shares. You're just asking for trouble. Get a proper SAN or local storage.

Are you looking for a deliberate flush, like a DBCC comment? The default trace might help.