Hi

Points
Table design should always have nullable columns towards the end.
Nullable Char columns occupy higher number of bytes than Non Nullable char column. This is basically because of some overhead involved in Nullable columns.

Could anyone give me the reason for the 2 points mentioned above.

Thanks And Regards

PG Thiagarajan


MS Sql Server LazyDBA home page