Re: NOT NULL

From: Doug Bernhardt <dbernhardt_at_usinternet.com>
Date: 1997/03/11
Message-ID: <33262BB0.3B7D@usinternet.com>#1/1

Minh Giang wrote:

Hi,

     How much performance degradation to a table with all fields   defined with
  NOT NULL compare to a table with one or two fields defined with NOT   NULL?   TIA
  --
  Minh Giang
  mpg_at_fast.net

Any character columns defined as NULL SQL Server will automatically store as varchar. Although varchars can save space, they have a performance impact because of the work needed to maintain these columns in the table as well as any indexes these columns are in. Received on Tue Mar 11 1997 - 00:00:00 CST