/*-----------------------------

select newid() as "BARCODE",a.* into part_1 from

master..sysobjects a cross join (select top 10 * from master..sysobjects) b;

-----------------------------*/

Table 'part_1'. Scan count 0, logical reads 1, physical reads 0, read-ahead reads...

If you are partitioning the data into 4 tables for performance reasons, then I think this might be defeating the purpose.

Since your search is based on a unique value such...

The row-based , set-based thing just confuses matters.  

Indexes (in SQL Server) are on the column values, when you have a criteria/predicate in a SELECT that has a function on...

Great article.

I know this is probably a bit off topic, but I noticed that you didn't mention COM+ transactions. I think there's quite a lot of developers out there using...