Fair enough.

I'm going to partition the table by date and use partition switching to expedite the process of loading data. The only caveat is that I have to drop the...

Thanks Erland.

Loading data by date, every week, is the main reason for redesigning partitions to be based on dates. I like your idea of generating an artificial key. Do you...

Thanks for your responses. They were very helpful

Thanks.

Will there be any performance degradation since most queries first go with Supplier and then date? In other words, do you see any chance of table level locks?

I have a big table which is currently partitioned on a column called SupplierName. We get new data every week, for each supplier, and inserting data into this massive table...