I want to count in 0 as i specified in my post, " ignore the milliseconds" its difficult to...

Thank you Lutz and Wayne. Yes I am looking for the diffrence in seconds in TranIn and TranOut columns

Jack,

thanks for the warning. this is a 3rd party app. and we are restricted by design. what we can do is adding few indexes as necessary.

Thanks everyone. hitendra's reply suits me best. thanks again.

Thanks Ken. The query plan looks great but query is generating arithmetic overflow error after the. let me fix it and give a feedback

Thank you Ken and Grant. Right now, i dont have access to real data. i will check it as soon as possible and post the results.

The original query plan

...

Thank you mohan and suresh. I agree with you. i would generate snapshot during non-peak hours. Thanks again.

Thanks suresh. But there is no 'Off hours' since the application runs on 24 X 7.

Thank you ed

Dear MJ,

Thanks for the post. We already have removed those objects. Got the error,

View 'dbo.sysprotects' is not updatable because the definition contains a UNION operator.

DBCC SHRINKFILE: Heap page 1:1136138 could...

Thank you for the reply. We are thinking to restore master database from old backup. Rebuilding master database is not the prefered option. Wonder, anything else can be done without...