SQL Server Performance

The order of columns in a table matters for different data types?

Discussion in 'General DBA Questions' started by sql_er, Aug 21, 2010.

  1. sql_er New Member

    Hi,I work with MSSQL 2000. When creating tables I never paid attention to the order and type of columns. Last week a co-worker mentioned that it is best to place fixed length data types first, followed by variable length columnsFor example, if I have a table with have a few integer/date columns and a few varchar, he suggested to place varchar last.Is it really better this way? If so, could someone explain in detail why?Thank you!
  2. FrankKalis Moderator

Share This Page