Checked further , it is populated in ERP system and they have restrictions on this format. 3rd party. Also there is no dd coming

We just get MM/yyyy.

Check if the query in the script is optimized or not. Try doing a plan on it.

Add / drop idx as required to boost the perf. see if this helps

Also...

autostats is turned on. How would you know which stats are USELESS and could be dropped? How to identify which update stats is taking the longest time ?

tried to drop this thread in wrong forum. no idea.

Appreciate your help.

Cannot define as date time.populated by othe application.noticed though defining function in sequential order, it reshuffles from 01/31/2009,02/31/2009...01/31/2010...12/31/2010...12/31/2011 01/31/2009,01/31/2010,02/2009...12/31/2010,12/31/2011 and the values are in the wrong partition

Congrats!!

How many days of reading would you recommend before taking this test ?

Also is this book sufficient for the test or anything else also ?

Are you aware...