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)
Best Regards,
Chris Büttner