Thursday, June 27, 2013

Performance issue with ISNULL function

Why not force a default value on the column? Since this is a boolean flag.



CREATE TABLE {TABLENAME} (
{COLUMNNAME} {TYPE} {NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE})




No comments:

Post a Comment