THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Page Free Space

See also my SQL Server technical articles on

A Tale of Two Index Hints

Published Thursday, September 23, 2010 11:44 AM by Paul White

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Brad Schulz said:

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!


September 22, 2010 7:37 PM

Paul White said:

Thank you, Brad!

September 23, 2010 6:41 AM

mjswart said:

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

September 25, 2010 10:18 AM

Paul White said:

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.


September 25, 2010 7:30 PM

J.Wilson Lòpez M. said:


October 2, 2010 1:32 AM

ManishKumar said:

Great Article :)

May 21, 2013 6:29 PM

Julian said:

index(0) is heap, index(1) cluster index

August 13, 2013 11:23 AM

Leave a Comment

Privacy Statement