This is a really good script for a quick overview of the desired table and its indexes. One addition that needs to be made though is to account for...

Thanks for your response, cap'n. I have that article bookmarked as one of my main tally table resources. Maybe I am just being dense, but I am not...

In all honesty, Vinu, I have no idea why their driver works faster. I figure since their business is providing finely tuned drivers for various database engines, they have...

I am not trying to hijack this thread; I am just making this information available to any interested parties.

We have this same structure except that the 2005 named instance is...

My company is very similar to other large corporations that carefully test general updates before they are rolled out to the desktop. The reason for this is that we...

The count for the second SELECT is zero because of the nature of the insert. The three separate INSERTs each have a CID of 1, so only the first...