this is the execution plan i renamed my original tables and columns.

is the information provided is sufficient

What is the cause of the problem ?

I have been using this statement for nearly 6 years in prodution i did not get any error...

Grant.! Good Point to know.

What about DTA statistics ?

are they not statistics?

How DTA able to do get those details(Statistics), which means that it was missed by Auto Update...

what is DTA Statistics ?

And what is DB With AUTO_CREATE and AUTO_UPDATE for statistics ON?

GilaMonster (4/8/2014)

---

Someone ran the Database Tuning Advisor against your database and probably accepted all recommendations without doing the testing which they should have done.

But, that's not a statistics object (what...

Why i am asking this is while running the profiler i got some tables saying that

_dta_index_TABLE1_9_117575457__K4_K30_K1_K6_K9_K21_K16_K13_K12_K17_3_7_8_10_11_14_15_18_19_20_22_23_24_25_26_27_28_29

SELECT M.* , COL1, COL2, COL3,COL9, COL4, COL5, COL6,COL7,COL8,COL10,COL12,COL11,COL13 FROM TABLE1 M (NOLOCK), TABLE2...

I have created insert script for tables.also added table4

is this sufficient

This will give about the sigle relationship, i am...

Plase find tables.txt, plan.sqlplan.sql(executionplan), Tab_data.txt for inserting into tables.

Hoping this information will help me in resolve the issue.

Tab_tadata.txt and plan.sqlplan.sql files are the table insert scipt and execution plans.

"DEADLOCK" is not a recognized table hints option in SQL Server.

So which database you...

Here is my tables sample data.

Here is my table's sample data.

Those are the existing codes.

i need to modify them.

Yes using dead lock will lead to incorrect reports.