When creating a table in SQL Server does the order of the columns matter?
Posted on 2011-03-15
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 ...