Thanks for the quick response

I didn't change the indexes, only the order

I dind't change the other querys since they already use the correspondant indexes, I only changed the first one...

Thank you, actually the blocking issue wasn't really that important, what i really...

Thank you,

I found the cause but is something that I can avoid...

that means that adding more log file do not help in any way?

Thanks

Actually my concern is that we have several dbs and ost of users, so I really need to be careful with the use of temp db, I like the approach...

I have a db trigger for that, but those tables where create prior that trigger

Another way? that db was moved from a now defunct server...

Ok lets do this, forget about the original problem

what I really want to know is for a suggestion on what is the best way to retrieve large amount of data,...

Ok, the T-sql program loads all the needed data into a table, then another process use that data for a webpage ( believeme all of that data is needed) that...

Hello,

It is a T-SQL program, the problem is that we really need that much info, I can't change the logic, And that info changes really often so the report must...

I am only getting 5 columns, all of then are small, what i am looking for is a way to select chunks of that data in a optimal way....

Yes, I am absolutely sure

Hi,

I forgot to say that the "like" is this way: column like '123456%'

so it is using the index and doing a clustered index seek

The thing is that I don want to add anything on the client side, isn't any other way?

Hi All,

I did a Full Backup, then the log Backup, everything is good now,

Thanks

I just did the Update statistics and retrieve the ten million rows is two minutes, so I am happy now

Thanks to all of you