When creating a table in SQL Server does the order of the columns matter?

I remember hearing a long time ago that column ordering in table creation matters.  That basically the columns with the 'lighter' datatypes int, bit, etc should go near the top and the 'heavier' ones varchar(2000), ntext, etc should go near the bottom.

Is this true?  I've been googling for more information but haven't found much.  I'm working on a schema for a new system that we'll be developing and I want to make it robust and scalable ... not to mention very well optimized.

Any helpful instruction would be greatly appreciated ...
DanNetwork EngineerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

DanConnect With a Mentor Network EngineerAuthor Commented:
One more:


so basically in general it doesn't matter but best practice is move the variable length nullable fields to the end of the table if you have a lot of them and the DB is expected to be large ...
DanNetwork EngineerAuthor Commented:
hmmmm I may have answered my own question.  Right after posting I found this article here:

DanNetwork EngineerAuthor Commented:
DanNetwork EngineerAuthor Commented:
Got the answer I needed ...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.