One thing about the code above. It is always going to produce a table scan, because...

Cafe du Monde in the French Quarter? Probably a few miles as the crow flies. I'd take a cab.

Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a long weekend. 😀 😀 😀

I would send...

Hey, back so soon, Steve? ...

Scott,

I'm about to go on a long weekend to New Orleans, so I'm in a really mellow mood right now and full of goodwill towards all mankind. ...

Sometimes I think MVPs are a real pain in the ***. Present company excepted.

Statement of fact: No single clustered index can ideally serve the needs of multiple queries searching against different columns of the table. Non-clustered indexes are indeed duplicated...

Scott, I respectfully have to ask for clarification. Whenever you add multiple columns to the clustered index, you increase the size of ALL nonclustered indexes on the same...

I'd like to suggest an alternative, since making multiple columns a clustered key increases the size, and degrades performance of all your non-clustered indexes on the target table. Remember,...

Are you running your query in the same database where the table was created?

Good topic !!

wolfkillj (7/8/2014)

wolfkillj (7/8/2014)

GilaMonster (7/8/2014)

🙁 EVE hasn't taken over my life. Not entirely...

GilaMonster (7/8/2014)

The Dixie Flatline (7/8/2014)

Wolfkill needs to know if there are tanks in EVE Online, as well as bombers.

Tanks are very important....

XML didn't catch on in ancient times because it was too much extra effort to chisel the tags into stone tablets. 😎

Like Grant said, the fundamentals are the same regardless of where the output goes. Where I work, we deal with hundreds of millions of rows and are guided by...