I have found that most of these type of attempts at stress testing are quite difficult to do properly.  Unless you can replicate the entire environment from the database server...

If I recall correctly we had a similar issue that was caused by our netbackup system.  We wound up scheduling the SQL backups and the NetBackup so that the SQL...

How/where do I view space used vs. log space?

The DBCC SQLPERF (LOGSPACE) command will display the log space and the % used for all databases on the server.

Should the size...

Check the collations on each of them.  You will have to either change the collation of one of the columns or cast the collation of one of them in the...

Apart from the apparent logical problems of your database design (T apparently has no key and hence allows duplicates) you could use the query as a derived table. 

Note, however...

Since clustering is really a Windows function, the Windows oriented class is probably what you need.  SQL Server really just rides on top of the Windows Clustering Service and installing...

That is a very different question indeed!  And a very difficult one to answer.  Since not all transactions are created equal the number of transactions is only one part of...

Sounds about right...  One bit of advice: do your homework and create as few database groups as possible.  Again, look for the commonality between them at the database level, while...

Would every role need access to each of the five databases?  And if so, you should look for the lowest common denominator.  It will probably turn out that many of...

Are you asking how to arrive at an estimate of how many transactions per second an application will generate, or are you asking how to measure how many transaction per...

I'm not exactly sure what you are after, but I suspect that you might want to look at the sqlstp.log file in your ../Windows directory.

The primary thing you will need to do is to install the correct drivers on your server.  From there you'll need to use the provider information to define the linked...

I don't see anything there that I can specifically address, but I would call MS to open up a ticket with them.  They'll charge you, but I have usually found...

While technically true, that statement may not be the best advice...  If you need to be able to recover your database to any point in time, you need to keep...

It sounds like you need to store the documents in an image column.  This is simply a binary "copy" of the existing document which would preserve all formatting etc...