Thanks for the replies guys. We are contemplating on going ahead with a two column approach, and unless someone(within the team) comes up with an idea, other than the exciting...

Thanks a Ton guys. Your points made me clear some misconceptions about "Size".

Could be but the context in which it was said made me believe that it was with relation to the disk size of the database. Besides this was a conversation...

Thanks for the reply, it did help.

I have additionally found that  Microsoft recommends the usage of their

Enterprise Edition (SQL Server 2000) [Source: http://www.microsoft.com/technet/community/chats/trans/sql/sql0326.mspx]

for dbs which are over 2...

Thanks for all the replies.

The structure which I had proposed (part of it) is under keyed.

Order

Wish you a everyone at SqlServerCentral (users and admins) a Merry Christmas.

Thanks for this lovely website.

Thanks for the input guys. I guess one needs to sort it explicityly instead of leaving it to the indexes to "get it right" for you.

I have a lot of respect for quotes coming from "real world" experiences.

If the sort order requested is the same as the clustered sort...

/*I declare a table variable here to hold the object ids from the Target tables returned by  query (select planid, 1,…..).

November 9, 2005 at 10:53 pm