Heh... try this...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Heh... I've been doing SQL for almost 13 years... at least he used books... I still write the answers on my shirt sleeve. 😛

Nah... seriously... breaking out the books...

Don't ever turn autoshrink on for TempDB... talk about fragmentation!

Check the log file (LDF) for TempDB... is that what's actually full?

That is, of course, if you don't have the time in a separate column... let us know.

If it's trully a DateTime column, then MAX will flush out the one with the latest time "auto-magically".

RML51 (10/29/2008)

---

Timely discussion.

I'm arguing with one of our VisualStudio/.NET developers about column order in tables. He's asking us to move columns around so they appear where he wants to see...

Damn! That's two times I missed the intended humor... ok... I'm going to my room to suck my thumb and twiddle my hair. 😛

AnzioBake (10/29/2008)

---

I tested the Solutions against the Test dat set that I created. The Table Contained 1 Million records with sequences ranging from 1-35 rows.

My Solution returned 670000+ Rows...

AnzioBake (10/29/2008)

---

hi Steve (SMunson)

To Test your Solution, I ran mine again as I made some changes. Execution time was 5 min 36 sec

I added a print statement after ...

Just a comment... my experience has been that even monster batch systems don't need parallelism in most cases if the code is well written and the correct indexes are in...

What... you're not already packin'? Thought is...

Greg Snidow (10/28/2008)

---

I know this is a SQL forum, but there are times when I, and this is just me, find it easier to do this kind of thing in...

Nice job, Craig... and great graphics! I'm gonna have to play... 🙂

What a great read... and how timely! I just went through something like this with my bosses! Well done!

Thanks Sergiy! 🙂