Gail put it very well.

If a clustered index seek is imperative, then a change to the clustered index is needed - or - you need to add the additional column.

However,...

That's some of the small stuff too. There is the other things like staying on top of research for QOD, editing articles and reviewing them for content, and the...

I say go for 2008.

In our environment we would have to compile it for three months. Some queries are only run quarterly and have enough of a positive impact on the query to...

Alter your query to the following:

SELECT TOP 120 A.[Page]

,C.[Category] AS 'PostCategory'

,A.[Title]

,A.[Notes]

,A.[Color]

,A.[CreatedOn]

...

It sounds like it might be an iso problem.

Here is a thread of the same issue, it might help:

http://social.msdn.microsoft.com/Forums/en-AU/sqlsetupandupgrade/thread/48ca1bfa-08d4-48b5-abb6-18682e27dc57

Try a copy and paste to a new browser window. Also, did you receive an error message?

Here is an additional article.

http://decipherinfosys.wordpress.com/2007/08/14/moving-tables-to-a-different-filegroup-in-sql-2005/

Just trying to get clarification on your question. Your initial post was on how to force a clustered index seek. With that achieved, you then asked how to...

Take your query and step it up a few notches. Make it an extremely complex query and then compare the cost on the sort. Also, compare it when...

Read the article I posted.

Here is an article that discusses how to move tables to filegroups

http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/

And maintain a clustered index seek?

Gift Peddie (2/9/2010)

I know SQL Server...

The cost will vary. It truly depends on the size of the table and the scan. Execute the query with the actual execution plan. Highlight your clustered...

I would take that a step further. Many companies don't know they...