Dave Ballantyne (6/3/2009)
Jeffrey ,Can you post a full XML query plan of one of your queries that Seek ?.
If you could try to make the query as simple as possible though, just one column / variable.
We may be able to gleam a vital piece of information from that.
I'd also like to see the plans, but with at least 2 columns/variables in the where and, if possible, a couple of different plans based on different parameters passed.
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