The article is fine and the rowcount analysis that he advocates is a good idea but I'm not a big fan of Profiler. It sucks up memory and is...

Thanks for providing some examples of things that didn't work and why, particularly the part about issues when you went from your local server to a production server. I...

Kirk Haselden is not one of the authors of this book, i.e. Professional Sql Server 2005 Integration Services. I've got it in my hand right now. The authors...

Personally, I would give this a 3 out of 5. I think that Microsoft SQL Server 2005 Integration Services by Kirk Haselden is a far superior book.

I clicked the correct answer and it still told me I was wrong. The stats are a little messed up as well.

I'm sorry, I just don't understand why anyone thinks the document is misleading. The first page indicates that there is only partial support for some category items. The...

Whoops. My bad. The database I happened to be connected to is the only one out of about 30 with compatibility level 80.

I think the QOD submitter would do well to actually test the scenario. The first answer is correct, i.e. all rows and columns in descending start_date order with start_date...

To make sure that we benefit from these large IO write size , the best disk configuration we found to handle 256 KB IOs (throughput vs latency ) is to...

You're absolutely right that RAID 0 has no redundancy and if redundancy is a requirement then, like you, I wouldn't bother creating a RAID 0 array as failure could be...

"Some of these shouldn't be allowed in my mind, like RAID 0 disks, which wouldn't be in a production system. "

I don't understand this line. I've seen and implemented...

Your answer implies that there is implicit referential integrity between a synonym object and the object it points to. The fact is, in BOL they specifically state that there...

There is a difference between a key and an index. A key is a component of the conceptual data model and does not have a physical representation. It...

The correct answer is, a qualified YES, since you can provide authentication information as part of the OPENROWSET statement.

You have to supply the credentials for the connection so none of the answer options were really valid for this question.

OPENROWSET

( { 'provider_name' , { 'datasource' ; 'user_id' ;...