I can see many warnings with your temp tables and column statistics. Is TempDb configured to auto create statistics?

SELECTname,

is_auto_create_stats_on,

is_auto_update_stats_on,

is_auto_update_stats_async_on

FROMsys.databases

WHEREdatabase_id = 2

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]