There is no strict way to find the last rebuil date time info...

Please refer the below links:

http://sqlblog.com/forums/thread/13120.aspx

http://www.sqlservercentral.com/Forums/Topic340343-149-1.aspx#bm340730

SELECT Name, MAX([Used Food]) AS Max_Used_Food

,COUNT(Name) AS Count_Food

FROM SomeTable

GROUP BY Name

I was little fast for the column header...try this.

SELECT Name, MAX([Used Food]),COUNT(Name) AS Max_Used_Food

FROM SomeTable

GROUP BY Name

Try this...

Adding a point, depends on the cluster key and its uniquness, the other non-cluster key will change.

Please refer the below:

http://sqlzealot.blogspot.com/2011/02/sql-server-index-details.html

I faced such issues sometimes back. I had separated the queries.

As long as you have many condition, it would be great if you can go for a dynamic parameterized query...

you canot enforce unique constraint with multiple null values for a column

DELETE CurIndividual FROM CurIndividual

LEFT JOIN CurAccounts ON CurIndividual.MemberID = CurAccounts.MemberID

WHERE CurAccounts.MemberID IS NULL

Can u try this....

Adding one more point....

Be a regular visitor of SSC...

We can probably think of creating a job and execute the script you have at scheduled interval.

We can even send alert mails using DBMail or SQLMail.

Are you encountering parallelism even you change it to MAXDOP1?

Please refer the below link.

http://www.ureader.com/msg/11581453.aspx

Thanks for sharing the document.

Again, it says the "Translation from parse tree to internal query representation requires some Normalization". Any idea what are the steps taken in those calculus representaion...

then its pretty easy as it is to move the records with the created date difference from the current date exceeds 10 days.

Use DateDiff function for the same.

Do you have any created date or updated date in the table? That would be the right key to purge the data.

Query engine does normalization? Could you please post the link which explains the same. That would be...