This worked for me. Thanks!

One thing I thought was interesting though was that I had the same exact parameter names (@START_DATE, @END_DATE). Could these be some kind of pseudo-keywords...

Thanks for the tip about the stats. I will analyze that part of the query seperately.

I've included a simple query that produces different execution plans. I'm wondering if it's...

I'm attempting to implement my first partitioned view. According to BOL I think I've got all of the necessary components and it seems to complete close to the normal timeframe...