If you merge this stuff, one set of values, say those from DB1, will get to keep their identities. The other set, from DB2, will likely have to change. Which...

End users typically don't work with the database. Unless it's Excel, and then you have concurrency, scalability, reliability issues.

All of the databases work fine. There's no "best". I think the...

I'll say this is one reason I think we need those yearly service packs. A more stable, tested version of patches that gets us to a level that can be...

CUs are released every other month. You can also check on this blog

http://blogs.msdn.com/b/sqlreleaseservices/

If the secondary is completely passive, not any clients accessing it, you only need to license the primary server.

However check with your Microsoft office in your country. It can vary...

Fair point, Bill, and I do try to disclaim that Red Gate pays my salary when posting about things. I neglected it here, and I'll add that as well.

Ha, where's the argument in that 🙂

I don't know if Andy's the best, but he's pretty good. Course, being a fellow Southerner, I like listening to the accent.

I'm not sure that's fair. They are trying to pick people that are recognized experts. "Best" is an opinion, and we'll never agree on it. I don't think that means...

You can't compare dates. Those are when SQL wrote to the file, which I think it does when it opens it, so you're looking at whichever one started later as...

There isn't a good way here. You need to move that much data, and it will block things.

I still question this is really needed. No one can use 5mm rows...

You need the space for data, and you need some pad space. This is for data growth and maintenance operations.

My apologies, Heather, for the implication. I was not aware that the Idera product had write capabilities. I have updated the editorial with a note as well.

Geoff is a good guy, headstrong, professional, and smart. I think he is an excellent choice, as is Andy, for the board.

5mm rows for a report is a little silly. There is no way anyone goes through this much data, even for an audit. And I can't see it being run...

*grunt*

I...