mattech06 (5/27/2015)
Can you see any easy optimizing of those statements (I know I haven't posted any data, sorry)
I was about to say 'execution plans, table definitions and index definitions', then I realised you're doing this:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
But other than that, table definitions, index definitions and execution plan please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability