Deletes and failed inserts are the issues. If you have some rollback, broken connection, etc. that doesn't complete, you'll have gaps.

It shouldn't be a problem. The identity isn't a row...

If you set to simple, then Gail is correct. But if you have it in full recovery for any reason, you need those log backups. Not necessarily for recovery, but...

I'm in, got the pwd from Simon and team in the league.

I'll likely auto-draft as I'm busy too many nights, but if I can join in, I will.

http://technet.microsoft.com/en-us/library/ms177410.aspx

I agree with Gail. I would run a log daily just to clear out the changes from that day.

Asking for a pwd for the league as well. Or is this a public league?

I agree with the idea that you rebuild what needs to be rebuilt. If you do each one individually, it will need log space for that index, but then it...

You could potentially build something, but it would be very cumbersome. The safest way is for you to track the old and new columns. I wouldn't do this in one...

Hugo is correct, a varchar(1) or nvarchar(1), doesn't make sense. It uses more space. Not much, but more.

I have typically gone with char(4) or less. When I get to 5,...

We have an iMac, and lots of Win machines here. I think building a machine can be fun, if you want to do that. Many techies like that, but many...

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...