hmmm, for some reason it didn't come out right, let me try again:
-------------------------------------------
The real problem with NULLs tho is that if you declare a column "NULL" able,
then the DBMS must keep a "NULL" bit in the database file for each row.
This makes the DB bigger (not by much, and is really irrelevant), but more
importantly the engine must do an extra "is this data NULL" check on all
select statements that touch this column. Compare the following:
THIS IS WHAT SQL SERVER WILL DO IF COLUMN IS NOT NULL
Return MyTable->ColumnA.Value
THIS IS WHAT SQLSERVER MUST DO IF COLUMN IS NULL
if (MyTable->ColumnA.NullBit != false)
return myTable->ColumnA.Value
else
return NULL
-------------------------------------------
Bryan Love ACP
[EMAIL PROTECTED]
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:58 PM
To: CF-Talk
Subject: RE: NULLs
True, but let me post a direct quote from a very good DBA friend of mine:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
