We're a long way from needing bigint, but if anything were to get that large, this would be it.

The tlog backup won't matter. If there isn't much happening, it's a tiny file. Better to have it than not.

As far as space, I'd agree you need 3-6 months of...

I don't have time to test, and perhaps this works better in 2005/2008, but I know that a NOT IN() or a has resulted in a table scan before...

I think lots of people Google, but lots of them don't know a) how to search and b)there are too many results.

I've seen people try to search, and the terms...

BTW, it's good to be back, and I have no idea what happened in this thread, but it certainly has a lot more posts.

Paul, I missed that one in the article, but as an FYI, when you write something, you do want to focus on the topic, and not get too distracted on...

I don't think it matters here, what is backed up and restored. If you back up the publisher last, that should ensure all changes are in the backup.

I'm not sure what you mean by server types. Do you mean subsystems installed? Do you have a list of what you are looking for?

These aren't "registered" with your...

Do you know what horizontal partitioning is? This sounds like an interview question. If you give us some thoughts, or what you think (or don't understand), we can help. It's...

Bi-directional is a type of transactional replication. Do some research on that. You can use merge, which gives you more control over collisions, but also it is more complex.

Snapshot will...

I think it's good to get away and recharge. Not sure about 4 weeks, but perhaps that's cultural. It's been a long time since I've taken this much time away,...

You should hire a consultant. If you are not aware of whether it's possible to upgrade, you likely do not have enough knowledge to do this. Hire someone, learn from...

You have to link the job to other servers (linked servers), or set it to run on all server instances. There is no linkage between instances to automatically determine what...

http://blog.sqlauthority.com/2007/10/23/sql-server-get-permissions-of-my-username-userlogin-on-server-database/

The SID shouldn't matter. You can map the login to the user.