>>The table has 10 million rows. The query is
>>select top 1000 * from sales where date > '1/27/2003'
>>and week_calculated = 0

Things to check

1. Do you have a clustered index ?
2. Do you have an index on that date field ?





You can always text the query in query analyzer and do a show plan on the query.

Do the following

1. Select you database in the Query Analyzer
2. Run the following in the query analyzer

SET SHOWPLAN_ALL ON
go

select top 1000 * from sales where date > '1/27/2003'
and week_calculated = 0
go

Post the text results here and we'll take a look at the problem.


Rodman