Where have all the new articles gone?

It's a good article and an interesting subject....but it's a repeat!

Also, since its original publication, we've had SP2, so some of the comments (notably...

Refreshingly well written article....but this 'issue' has been present for a very long time (long before SSIS) in Enterprise Manager.  You can fall victim to its consequences, no matter how you...

Can't you use the same table (partitioned maybe)?

Adding a new table each time sounds like a recipe for disaster to me.

Confession....I hadn't read what I was posting.  I'd sort of ignored the first line, and just focused on "Each query should contain a query hint or a comment explicitly...

Thanks, Gail, for your input.

They're both int datatype, so it's not a huge increase.

I think it's the most appropriate place for the cluster, as the table is typically joined on these two...

Cheers, Grant....I'll get my script together!

You've provoked me into replying, Peter

I don't see it in such simple terms (just compare execution plans)

I don't think all code has to be...

One point I missed is the impact on the other (non-clustered) indexes.  The pointer back to the clustered index will change from being one field (Field1) to two fields (Field1...

This is true....but I still like it!

When I'm next confronted with this type of situation, I'll have a hard time choosing between these two methods.

Previously, I'd have gone for a solution like...

Is it really a CROSS JOIN?  Or does the WHERE clause not basically act like a join?

Thanks Minaz,

I think you're missing my point.  Clearly from the code there is a non-clustered primary key and a clustered index.

The clustered index covers one field, which is the first...

Wow...2 excellent and elegant solutions, Peter and Jeff.  (And not a max in sight!)  Can't wait to see what else is proposed.

I'm glad I could be of help.  I hadn't thought of rss as a possible application.  I have written an rss feed coming out of SQL server, but I basically...

Hi Barsuk,

I have VB6, VS2003, VS2005, SS2K, SS2005 all on the same box, and have no problems using both.

Thanks Ken - works a treat!