Have you tried setting the format options of the textbox ?

Its not all bad though...

http://www.sqlservercentral.com/Forums/Topic987019-1292-1.aspx

Most likely the queries are bad.

Ensure that you have correct indexes, and that those indexes are being used.

Can you post a query ?

Views dont have stats, as they look to the underlying data.

This is tough to diagnose like this , though i feel the answer is in rewriting you queries.

That will take...

Try not using { FN CURDATE() } , which returns a char but getdate which is a datetime type.

Can you post the view code ?

I would like to see how PS_NAMES ,PS_JOB and PS_PERSON are joined.

Check that the Stats are actually updated with 'DBCC SHOW_STATISTICS'

sp_updateStats, to quote BOL

updates only the statistics that require updating based on the rowmodctr information in the sys.sysindexes catalog view, thus...

Just as a stab in the dark , are you joining on the results of udfs ?

You might be seeing this....

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/07/02/using-a-udf-as-a-sarg-make-a-hash-of-it.aspx

Please post the plans as per

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

DTA will not help you if your queries are poor in the first place, such as the one stated in one of your other threads.

http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx

Cross post....

http://www.sqlservercentral.com/Forums/Topic986023-360-1.aspx

http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx

By posting multiple similar questions , you are helping no-one , least of all yourself.

Lets deal with you specific select issues first.

Probably for the same reasons i have stated in your other thread

http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx

Though its good you have posted the plans, what statement is causing the Timeout ?

This is probably the root cause.

Two links that will help you...

http://www.karaszi.com/SQLServer/info_datetime.asp <--- Required reading IMO

and check out Rob Farley's "Sargability" Session from...

The major cause of performance problems after an upgrade is not updating statistics.

Try that , if thats no help then post the execution plan.