A Tale of Two Index Hints

re: A Tale of Two Index Hints

Brad Schulz — Wed, 22 Sep 2010 23:37:04 GMT

Wow! Every new post is like another new treasure.

Thanks for another great post. I'm always learning something... I never realized that an IAM scan was even available... yet another reason that it's a big mistake to make any kind of assumption on the order of a result set (when you don't specify an ORDER BY).

I marvel at the complexity and depth of the optimizer... and I marvel at your continued excellent output.

Thanks, Paul!

--Brad

re: A Tale of Two Index Hints

Paul White — Thu, 23 Sep 2010 10:41:58 GMT

Thank you, Brad!

re: A Tale of Two Index Hints

mjswart — Sat, 25 Sep 2010 14:18:11 GMT

After last T-SQL Tuesday I thought I was indexed out. But this is a great post. It must have taken a lot of investigation.

Good job

re: A Tale of Two Index Hints

Paul White — Sat, 25 Sep 2010 23:30:24 GMT

Hey Michael,

This was going to be my first contribution to T-SQL Tuesday, but circumstances conspired against me. I'll try to be better organised for the next one.

Thanks for the kind words.

Paul

re: A Tale of Two Index Hints

J.Wilson Lòpez M. — Sat, 02 Oct 2010 05:32:55 GMT

GOOD JOB! ...from COLOMBIA