Thts the first thing i did. It didnt turn out the way i wanted. Index fragmentatin did not increase.

I have narrowed down some tables to defrag operation. Their index fragmentaion...

ofcourse it is.

okay. Thank you.

MSDN does not have a page for maximum specification like it has for database engine.

Yes, thats an separate issue/discussion; would be taken up later. Need a temp fix. Is there a limit? or can we give any values like 10K?

okay. i will get the index information. meanwhile, running DTA, shows that i need to create another 2 NC index on table2. I also ranmissing index dmc. It also showed...

SELECT

TABLE1.field1,

TABLE1.field2,

TABLE2.field1,

count(distinct(field4)) as Counts,

(count(distinct(TABLE2.field2)))

FROM TABLE1 LEFT OUTER JOIN TABLE2

on TABLE1.field1 = TABLE2.field1

WHERE

TABLE1.field4 >= 'dd/mm/yyyy'

and TABLE1.field4 <= 'dd/mm/yyyy'

and TABLE1.field1 like 'CloudSA%'

group by TABLE1.field1,

TABLE1.field2,

TABLE2.field1

order by TABLE1.field1 asc

Field1nvarchar100

Field2varchar5

Field3datetime8

Field4nvarchar100

Field5nvarchar100

Field6nvarchar100

Field7datetime8

Field8datetime8

Field9nvarchar100

Field10nvarchar100

Field11nvarchar200

Field12nvarchar100

Field13datetime8

Field14nvarchar200

Table2

Field1varchar50

Field2varchar50

Field3varchar50

Field4varchar50

Field5varchar50

Field6varchar150

Field7varchar50

Field8varchar50

Field9varchar50

Field10nvarchar300

Field11varchar50

Field12varchar50

Field13varchar50

Field14varchar50

Field15varchar50

Field16varchar50

Field17varchar500

Field18varchar50

Field19varchar100

Field20varchar100

Field21varchar100

Field22varchar100

Field23varchar100

Field24varchar100

Field25varchar100

Field26varchar100

Field27varchar100

Field28varchar100

Field29varchar100

Field30varchar100

Field31varchar100

Field32varchar100

Field33varchar100

Field34varchar100

Field35varchar100

Field36varchar100

Field37varchar100

Field38varchar100

Field39varchar50

Field40varchar50

Field41varchar50

Field42varchar50

Field43varchar50

Field44varchar50

Field45varchar100

Estimated plan shows...

Reading the package XML is the workable solution. Starting to work on it.

Worked like charm. thanks.

I have stuck up on insert. I ran insert in child table. it gives referential constraint error (with parent table). so i try DELETE parent table. It gives same error...

It means i need to know the parenta, then the next child B, which is parent to another table C. Is there a way to find that exact sequence of...

Yes, i do have the list of FK for the parent table. But when i start deleting in child tables it throws up error. I dont know if i have...

Nobody ever came across this info? 🙁

Awesome. A job ws running which was running the query. Thanks for pointing to the problem.

So, its 100% sure that an sp_execsql does not pass control untill the query is...

I am using cursor for the loop. It is an rebuild operation query. I am also testing the same logic for taking backup/restore, file cleanup from folders.

I faced this error--

Could...

I am using the ErrorLog table given in MSDN. I will check the documentation first.