"Novice" my butt :)... you've been paying attention. 😉

Well I'll be damned... didn't even notice until just now... 12,000+ posts... Steve owes me a shirt or two! 😛

I guess if...

Heh......

Sorry... almost forgot... borrowed on Carla's good code and expanded the test data set a bit for my testing...

CREATE TABLE PersonRecord ( PersonID int NOT NULL, Version int NOT NULL,DEDate...

You should see what happens with the correct and incorrect indexing. Adams code (using his because Carla rated it as the fastest) is more than twice as fast as...

Sorry... looks like those were CPU times.

Carla Wilson (11/12/2008)

---

I was curious how the different techniques performed, so I loaded up the PersonRecord table with more data using a Numbers table (please see article http://www.sqlservercentral.com/articles/TSQL/62867/ [/url]for Numbers...

Will Riley (11/12/2008)

---

Why bother with views?

Why not construct a UDM (Unified dimensional model) layer over the reporting database instead and create report models for your report builders to hit. That's...

ggraber (11/12/2008)

---

Not really, Jeff. Thanks for asking. 🙂

What I'm really looking for is performance comparison between CTE and Derived Tables.

I...

I've gotta dog-ear this page... all those in favor of developers having write access to production boxes, raise your hand! 😛

Patrick Russell (11/12/2008)

---

Below is the code using the restructured WHERE clause you posted. In testing I saw no noticable difference;...

goodguy (11/12/2008)

---

I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent...

Um... for what? Using a paltry 40 MB of TempDB? Fragementing the disk because TempDB started out insanely small. ...

Thanks for taking the time to say so! Keeps folks like me going. Thanks CM...