That's kind of a tough one...  sp_who2 which just pulls the info from sysprocess reports on cpu usage, but it is cumulative, so it can't really tell you which process...

I don't use the ITW much, but I have used it in the manner you describe.  I don't recall any problems at all.

you can also issue this command SET STATISTICS TIME ON and then do your queries...

Rudy, that may not be true, particularly if the different logs can't be separated onto different disks/arrays.  If the transaction percentages are correct it might be better to have a...

Although SQL Server can split work in a single transaction over multiple processors, it is often more efficient NOT to.  There is quite a bit of overhead incurred in coordinating...

Unfortunately, SQL Server has no built-in capability to help you here.  There are several third party tools that can do this (or approximate this functionality) InDepth for SQL Server by...

Another persistent myth of the database world.  Make no mistake about it, it IS a myth that character data types necessarily offer inferrior performance to numeric data.  Your search arguments...

**disclaimer** I am not a MS employee and am certainly not authorized to provide definitive licensing answers***

I believe that if each of your developers have an MSDN license you are...

If you are doing the restores at the same time so that they will be synched up in case of a restore you may need to rethink things a bit. ...

IDENTITY columns are nothing more than a specific implementation of what are generally known as surrogate keys.  There are several ways to generate surrogate keys, but for SQL Server the...

It sounds like you have servers that will give you a lot of room to grow...  I doubt that the reboots either help or hurt performance.  There will be a...

Of course the publishing world is where XML got its start.  As you said David, it is a method to separate format from content.

I won't claim to be an expert...

Wow!  MS and IBM MUST know what they are doing!  Thanks for opening my eyes man!  I never would have thought of such a brilliant line of reasoning by myself! ...

I would laugh if it weren't so tragic...  A "standard (XML) schema"??  Is that a bad attempt at a joke?  That's what EDI tried to be, and XML will never...

The poster is obviously ignorant of data management fundamentals and sound system design (and hasn't carefully read the article or the other posts).  Just how is XML necessary, sufficient, or even...