|
by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 8/10/2009 7:10:00 AM
OK, for years I've been saying that SQL Server doesn't care about the order in which you define the columns of your table because internally SQL Server will re-arrange your columns to store all of the fixed width columns first and the variable columns last. In both the fixed-width portion of the row as well as the variable-width portion of the row, the columns are defined in the order in which they are declared. So, what does matter?
It's all in the cost of the variable array'
... [ read more ]
|
|
