BIT of a Problem
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Mon, 24 Jan 2011 07:00:00 UT
Indexed on
2011/01/29
15:30 UTC
Read the original article
Hit count: 233
Filed under:
The BIT data type is an awkward fit for a SQL database. It doesn't have just two values, and it can do unexpected things in expressions. What is worse, it is a flag rather than a predicate, and so its overuse, along with bit masks, is a prime candidate for being listed as a 'SQL Code Smell'. Joe Celko makes the case.
Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
© SQL Server Central or respective owner
