There is the issue. I cant look at the execution plan in prod env. Restoring prod backup to non-prod envs involve lengthy process. 🙁

The indexes are appropriate. I looked at the query plan in one of the other env where there is relatively lesser data. It seems to do an index seek on...

Hi Peter,

Information_Schema.Tables is a system view. It is available as part of all sql server databases. Kindly let me as to which version of sql server you are using.

Not sure if there's any whitespace problem. Please use the below query.

;With CTE As

(SelectObject_Name(constraint_object_id) Constraint_Name,

Object_Name(parent_object_id) Table_Name,

C.name Column_Name

From sys.foreign_key_columns FK

Inner Join sys.columns C

On FK.parent_object_id = C.object_id

And FK.parent_column_id...

Not sure if there's any whitespace problem. Please use the below query.

;With CTE As

(SelectObject_Name(constraint_object_id) Constraint_Name,

Object_Name(parent_object_id) Table_Name,

C.name Column_Name

From sys.foreign_key_columns FK

Inner Join sys.columns C

On FK.parent_object_id = C.object_id

And FK.parent_column_id...

Hello,

It might acquire table locks but not necessarily end up in a deadlock situation. You might want to delete records in batches for each organization and so that blocking is...