title: I need a slow query on AdventureWorks (SQL 2005)
body: <p>As an exercise (read:interview question) in index optimisation, I need a query which is slow on the standard AdventureWorks database in SQL2005. All the queries I've tried take about 1 second and I would prefer to have a query which takes multiple seconds so that it can be optimised effectively.</p>
  
  <p>Can anyone here create such a query or give me pointers to how to create a slow query? I just can't seem to make my queries non-performant :)</p>