LOL... not a problem... you should see what I miss before my first cup of coffee

Tracey,

What's going to be really hard is when you get all of this figured out and realize that all the load balancing you're trying to do with TempDB is nothing...

If the data "mirrors some of the issues", then the data might really have a problem.   Yes, your code does work... but it's...

Would you care to post your solution, please?

Yes, I do... why do you have different product names for the same ProductID's?

Heh... I'm no stats Ninja, either... but it's a heck of a lot more random with fairly even and unpredictable results over both small and large ranges of data than the...

You know me, Ryan... extraordinary claims require extraordinary proof... got code to prove that?

I don't see any records in your post...

Yes, there are some tables that know exactly which rows have changed... trying to teach you to "fish" a bit... read about "Triggers" in Books Online.

What say the da?

When I first started to read this, I thought "Jeez... that's a little obvious, Andy.  Hardly worth an article."   Now that I see...

You still mean writing in embedded SQL or what?

I'll go one further...

"Monitor and tune database resources and activities for SQL Server databases"

Does that include being allowed to beat the hell out of developers that write performance challenged code?...

Sorry... If your interview was for the postition of DBA and you do not know these things, you are simply not qualified to be a DBA.

This smacks of a "paging" problem... is that what you're trying to do?