193 reputation
6
bio website grandjean.net
location Northeast PA
age 34
visits member for 2 years, 2 months
seen Mar 11 at 16:59

Dec
3
answered Access ODBC reserved error 7711
Oct
27
awarded  Popular Question
Jul
20
awarded  Scholar
Jul
20
accepted Column definition for a SQL Server equivalent to Access BOOLEAN type
Jul
19
comment Column definition for a SQL Server equivalent to Access BOOLEAN type
+1: I'll have to do some quick testing in my front end (MS Access) to see if the 1 vs -1 will be an issue for me. One thing that I have relied on in the past is doing an ORDER BY on a Yes/No column in Access. In ASC order that means the TRUE items show first then the FALSE ones. There may be other considerations as well, but your point about up to 8 BIT columns fitting in a single byte is well taken.
Jul
19
answered Column definition for a SQL Server equivalent to Access BOOLEAN type
Jul
19
asked Column definition for a SQL Server equivalent to Access BOOLEAN type
Feb
3
awarded  Self-Learner
Feb
3
awarded  Supporter
Feb
2
awarded  Teacher
Feb
2
awarded  Student
Feb
2
comment Semi-Annual archiving of SQL Server database
I came to the same conclusion. The described use case seemed to be a perfect fit, but the devil seemed to be in the (implementation) details. I think if I went with this I would lie awake at night wondering if my db was corrupting...
Feb
2
answered Semi-Annual archiving of SQL Server database
Feb
2
answered Semi-Annual archiving of SQL Server database
Feb
2
answered Semi-Annual archiving of SQL Server database
Feb
2
asked Semi-Annual archiving of SQL Server database