i will suggest to keep the TRIP_STATS table separate from main table TRIPS ans TRIP_DETAILS

there is NO guarantee that performance will improve, CTE is basically used...

check with sp_who2 , which spid is locking that table

then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there

then decide which spid you can...

just came to know that this is duplicate post.

it wastes poeple time , dont cross post.

original post http://www.sqlservercentral.com/Forums/Topic1411020-391-1.aspx#bm1411043

check with sp_who2 , which spid is locking that table

then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there

then decide which spid...

Since there is no complete table definition will be not accurate suggestion from us.plus no idea either you have clustered index on tables or not ?

anyways

Order table will...

see this http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/

DDL trigger , extended event , profiler trace. etc.

this is...

Yes

nishantshende-532951 (1/24/2013)

---

I think the execution plan is taking much time, so can anyone tell me how to save the execution plan. So that the procedure will take 1 second even...

thbaig1 (1/23/2013)

---

can I DELETE DATA FROM tblQuantityP.ProductId in a way IF parent TABLE has NOT record against it ?

e.g. Prod1 with ProductId 1 removed from tblProduct, can I DELETE ONly...

Any other reference ?

do FK are with "on cascade delete" option ?

still you havent posted what all i asked

anyways

i will suggest you to take batch approach for "Deletion" . and i dont think "periodic statistics updation will help you...