I got the answer.

This Table Pool/Lazy Pool is to do with Nest Loop join. The query we did has a LOOP JOIN hint, which cause the Pool operation. Using HASH...

This works.

Thank you

Thanks guys.

So it basically the logging process slow down the delete operation.

Is there a way to turn off transaction log, like one can do in Oracle ?

Thank you for reply.

The database is in Simple Recovery mode. Does delete still be logged ? I did not observe large increase in log file.

Thanks for you input.

Thanks. Thal all help.

Hi, where can I find this BOL. The script is just what I want, I do not mind it has a bug or two.

Thanks, Guys.

A use can see all the databases listed under Databases in EM even he has not access to them. But he can not see any contents of a database, such...

Let me put my question in another way.

Suppose my SQL Server serves 1000 concurrent users and I were told it is slow. I would do the following to try to...

Thanks Gabor.

Do you need to configure SQL Server in any special way, like change server and /or database options, to support over 1000 users, or just take the default...

Thanks.

This explains many things. Is it documented somewhere?

The commands

BACKUP LOG [DBName] WITH NO_LOG

and

DBCC SHRINKDATABASE ([DBName])

should work perfectly. You can also run...

Thank.

The articles are very good.

Thanks. It works.