Is it important to declare your columns as NOT NULL

(Simon Sabin) Yes Yes Yes. Nullable columns cause a extra data to be stored in your table and index to identify if a column value is NULL. This is caused a NULL bitmap. you need one NULL bitmap 8 NULLable columns. So on table with multiple NULL columns the overhead may not be large.

Read More - Register for Free Membership