Chris,

Can you confirm if any other application is running on this server , which may be taking the resources and making your sql server starving for resources.

Also if it possible...

I would suggest pickup of any simple query and follow the below step

SET STATISTICS IO ON

<YOUR QUERY>

SET STATISTICS IO OFF

just see the if u are getting physical reads if yes...

No but using that function on the data would require some resources and would be a costly affair. I recommend first just test the result and execution plan of the...

You seems to be using a lot of functions on the fields in the select. Most of it is converting DateTime field to 112 format. IS that be avoided. As...

understand what you are saying but why i am not getting anything in the Execution plan or STATISTICS IO. Does they aggregate the cost and then show??

The example again is...

I understand what you are saying but why i am not getting anything in the Execution plan or STATISTICS IO. Does they aggregate the cost and then show??

The example again...