There can be a perfomrance gain, even with the files on the same RAID array. If you have multiple CPUs, SQL Server will/may spawn one thread per file for DiSK...

Check out GB PVR (http://www.gbpvr.com). It's based on C#, free, and pretty easy to set up. I was using it before I got a Time Warner DVR (Scientific Atlanta)...

That  "Transaction sequence number and command ID" are what you can search by (xact_seqno and command_ID, if I remember correctly) in msrepl_commands.

What type of replication?

I don't know if it will be the same in your implementation, but on ours you can look at the error and it will give you an...

Check out sp_start_job in SQL Server Books Online:

sp_start_job

Instructs SQL Server Agent to execute a job immediately.

IIRC, the technology in the Cryptonomicon is Van Eck Phreaking, and it does supposedly work.

You can go into the Replication Monitor in SQL Server Enterprise Manager (it's the picture of the green jagged line icon) and stop it there (I'd stop both the log...

That's why it is pick the BEST answer. It's a safety net for test writers (like certification tests, educational testing, etc.). If the question is a little bit off (like...

I agree with your 'picky, picky' comment, Steve. The 3rd normal form is the "best" answer to the question.

The problem is when you read people's books and or writings...

Quote from Handbook of Relational Database Design (Flemming,  von Halle).

"Reduce Third Normal Form entities to Boyce/Codd normal form by ensuring that they are in third normal form for any feasible...

Right. I thought I said the same.

Truncating the table would bypass the recording of every row deleted in the transaction log (and delete all of the rows from the table as well). It would still log...

If you already have two (or 3 or 4) Windows nodes clustered, when you install SQL Server Enterprise Edition, it gives you a choice of installs (virtual server vs. local...

Clustering SQL Server 2000 requires Enterprise/Advanced editions:

Windows 2000 Advanced Server (or Windows 2003 Enterprise Edition) is required for clustering Windows. You don't want to try clustering with NT 4.0 Enterprise...

Simple mode doesn't mean no log is written. It bacically means that you are truncating the log on checkpoint. All data modifications still go through the log, it is just truncated...