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!
See if this helps: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Column-order-doesnt-matter-generally-but-IT-DEPENDS!.aspx