debanjan.ray (1/24/2013)
One of simple delete query is taking more than 10hrs to execute. There are more than 12 foreign keys dependent on that table. Query is like this,Delete from Some_Table where table_sr_key !=-99 and sector_id=@some_code
Two questions :
How much data it contains ?
and do FK are with "on cascade delete" option ?
Also post table defintion along with index definition
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)