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.

Can be either one, but typically it's an admin that has rights to do this, not necessarily the DBA.

MCSE isn't a job, it's a certification, by the way.

You can use CPU time, but if you're looking for overall time, you need duration.

I like George's first suggestion. Go in chunks, use shrinkfile.

Also, you should not be shrinking the log regularly. If they need that much space, then they need it. Log shipping results in regular log backups, that allow space to...

If you need to restore a database from 2005 to 2000, no matter what the compatability, you can only script out objects and permissions, and run that on 2000. There...

I'm not sure there's a reason to pick one over the other for simple tests, but as you get into queries, testing for equality can be more efficient. People often...

Usually there are some ports that are "listening", look for those.

SQL Server prints this in the error log as well when it starts, so you can always check there. The...

Wayne,

Sorry, I need to update the IFCode, and I'll do that tomorrow. The code formatting has been a challenge, and it's confusing to everyone. I wish there were a better...