Home Forums SQL Server 2008 SQL Server 2008 - General Very Small Tables RE: Very Small Tables
Michael Valentine Jones
SSC Guru
Points: 64818
More actions
October 24, 2012 at 4:28 pm
#1552466
Often, small tables are used as foreign key lookups.
In that case, I prefer an surrogate integer clustered primary key to minimize the amount of space required in the child tables.