I had tried number of ways with row number and CTE...but never thought of adding '/' between parent and child sortorder field...I was trying addition, simple concatenation.

Could you please help...

This is perfect...Thankkkkk you very much !! Dont know why I spent so much of time on this 🙂

I am really not sure but this is that table structure with data that is given to me. Would really be a great help if someone can help. I...

I have been monitoring some metrics and Pages/Sec value is very high constantly. I think Pages/sec value means number of pages read from Disk per sec and high value...

Jeff - Thanks for sharing your experience. I understood that hardware upgrade may or may not help but I have to get ride of slow queries first.

@Grant - thanks for...

Just would like to add here - Memory:Pages/Sec counter value is constantly at 100 along with very high CPU utilization.

Could that be only issue of badly written queries or hardware...

Rob - I am running it on same development machine.

Thanks John.

My new hourly log backups are only in MBs. This means its not appending, right ?

In what...

Thank you all for taking time to help me on this. Finally, I took the backup of log file (Gila was correct on 79 GB 🙂 ) and then shrunk...

Thanks John, Gila and Tee.M for your inputs. Seems like I have to implement new back up plan on priority. GilaMonster - your article is very interesting and informative. I...

Hi John,

No, we are not doing log backups at this moment. Only full backs daily.

-Bhimraj

Hi Garadin,

Thanks for the query. Yes, there is a column "SerialNumber" which can uniquely identiy the items within Salesorder. I think that can be used.

@jeff - sorry, my...

Sorry for delay in reply and THANK YOU all for the solutions you provided here. Your help is very much appreciated.

Solutions provided by parthi-1705, sachin-355820, irobertson - is what...

Thanks for your help Gail !!!

Yes..Those are actual plans....