Great Article! Just one comment on indexing table variables: It actually is possible, just a little limited: You can create unique or primary key constraints on single columns.

Example:

DECLARE @MyTable TABLE (

ColA int NOT NULL PRIMARY KEY CLUSTERED

,ColB int NOT NULL UNIQUE NONCLUSTERED

)

But you cannot create such constraints on multiple columns (eg. primary key on ColA and ColB)