If you recreate it with a smaller size, I think that's what you're looking for.

DISTINCT is an aggregation. Will it always increase execution time? No, but it frequently does. It's usually put in as a crutch because someone doesn't know how to properly write...

Just can't tell you a thing beyond what Jeff has suggested without seeing the execution plan.

Numeric 19,0? Not an integer or a bigint? Is that data type the same as...

It sounds like you've hit a regression. These are edge cases where a query that, honestly, should have run slow in 2000, didn't. But now, it does. Every edge case...

The conversation bounced around a bit, but it sounds like you could use three things. First, and most importantly, a well documented development & deployment method that you can enforce...

More than likely it filters the tables and then combines the results. But, you should look at the execution plan. That will tell you precisely what happens.

This is how Microsoft suggests you get that job done.

There are several different tools from various vendors that advertise this feature, but frankly, they're either weak or dangerous. I wouldn't recommend using any of them at this point in...

Those are ANSI standard settings. I'd say it's a good practice to have them on, but I don't think you'll see performance and indexing changes from having them enabled.

What performance...

Perry Whittle (8/17/2011)

not available in SQL Server 2005, you will need...

The end of the backup process marks transactions as rollforward or rollback depending on if they're completed or not when the backup finishes. So you can get both situations, the...

The size of the transaction log is usually reflective of the size of the transactions. Have you tried monitoring the freespace in the tran log during the index rebuild. I...

A server side trace capturing a reasonable number of columns and events (depending on the events, statement level execs for example would be bad) will not be noticeable on most...

Or Team Foundation Services, or Vault, or SVN... anything but VSS.

I'd suggest doing a search online for Bill of Materials database designs. There are a bunch out there because it's a common problem. Use one of them as the basis...