sp_help <tableName>

Some of the points below might lead to the answer :-

1. ISOLATION LEVEL of the query

2. if the Stored Proc is using many INSERT/UPDATES in it, it might worth looking...

If the records are unique, u might try using UNION ALL instead of UNION.

regds/ramanuj

If the Stored Proc was created sometimes back, it might be worth trying recompiling the Stored Proc. With that, it recreates the Execution Plan for the SP w.r.t current database...

Hi

1. With: tDocArchive.doa_batchorder%1 < 1 :: It uses "Nested Loops" JOIN whereas without ...%1 <1 it uses "Hash Match" JOIN.   HASH JOIN uses more memory w.r.t. Nested LOOP JOIN. The execution...

Thanks Koby for your efforts to help me out of the problem. Your website provides information of OS Disk fragmentation in general.

 I am looking for Fragmentation, internal allocation of data...

Thanks for all the information.

I have gone through Ken England's perf. Opt book as well.

I am also aware of DBCC PAGE, DBCC EXTENTINFO, etc DBCC commands, but I am still...