SqlServerKudos - Column order doesn't matter... generally, but - IT DEPENDS!

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Column order doesn't matter... generally, but - IT DEPENDS!

published 348 days, 6 hours, 33 minutes ago posted by

sa 354 days, 23 hours, 2 minutes ago

Column order doesn't matter... generally, but - IT DEPENDS!

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?

category: Management | clicked: 4 | | source: www.sqlskills.com | show counter code

tags: Design, SQL Server 2005, SQL Server 2008, Storage Engine

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos