T-SQL: Performance Issues with View; runs slow

Does the query produce the expected result?

Query optimisation can be done out of thin air. Do be able to assist we need the CREATE TABLE and CREATE INDEX statements for all tables in the queries. (And if they are views, we need their definitions etc). We also need to see the actual query plan, and we need the XML, not only a screen shot of the graphics.

With the query plan, this will be more than a mouthfull to post here, but if you can upload it do Dropbox, Skydrive a web site or whatever that would be great.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se