Can you tell me what is your maintenance job scheduled for?

Tanx

I created indexes for my temp table but still the issue persists . table scan costs 100%.

[Microsoft][odbc sql server driver][SQL Server]Lock request time out period exceeded

error:1222

Thax

thax

can you please tell me more on statistics and how to use it for improving performance.

can u give some real time situations where we use these three to improve performance...