Sql Server Performance And Order Of Fields -

does order of fields creation in table effect on performance of commands on table? if answer yes, can discuss it?

for example have create table this

create table software(int id,alpha datetime,beta datetime,title nvarchar(100),stable datetime,description nvarchar(200) ) 

if change to

create table software(int id,alpha datetime,beta datetime,stable datetime,description nvarchar(200),title nvarchar(100) ) 

is there performance effect ?

is clear?

the field order makes no difference whatsoever (if fields same of course)

the on-disk structure remain same pretty regardless. simply:

• header
• fixed length columns
• null bitmap
• variable length columns

all you're doing above rearranging columns inside "fixed length" , "variable length" sections. however, same processing required retrieve them no matter order in.

see paul randal's article