Can you post the schema, indexes, and execution plan attached in a zip file?

That will help seeing the problem, and we might be able to help better.

How many rows is...

Nice one Bob, I like the Replace idea. It's pretty wise.

As I can see, there does not seem to be a built in format to do what I expect to...

This is a possibility, but I checked with the programmers, and they said they never close a database after use, they only close the connection. And the program uses a...

I still have a weird problem with this. The database keeps starting. It takes 2 secs for the database to start, and if I look at the log closely, everytime...

I reran the same query, and it now runs in 1 ms, the stmt and the RPC call.

I guess the database needed to start, maybe because I restored the database....

When i look closely at the trace events I see a Stmt Completed, but just before that, I see a "Starting Up Database". I don't see the time it took...

Yes, they are related, it is the query completion, and RPC call contains only the query :

This is the Stmt Completed, which finished in 1ms, and returned 0 rows:

SELECT...

Ok, but there is no Stored Procedure, it is only a query that is sent using the VB.net Application. I know that a lot of small StmtCompleted can make a...

Thanks a lot Jonathan,

Makes it a lot more clearer to my mind. 😉

By the way, the operation is almost done, only got 1 million rows left to delete.

Thanks again,

P.S. Lynn,...

Does that mean I...

Hi, thanks for the replies,

Unfortunately I cannot move the data and put it back, since the data has to stay available. So I think the 1000 rows batch delete is...

Hey, I had already declared the variable that way, it does not help the query, thanks for the try!

J-F

My bad, you're right, wrote it too quickly, thanks for the correction.

Simply add a where on the key,

Thanks,

J-F

Hey, thanks for your input all of you,

The index you proposed are about the same as mine, I already got some covering indexes there. But thanks!

For the "Force Order", well...

Hi,

Thanks for the reply, but it has the same exact execution time, and it used the same query plan (still says it selects distinct records). I think the query gets...