Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
Browse by Tags
All Tags »
bitmasks »
T-SQL (RSS)
Sorry, but there are no more tags available to filter with.
-
Originally posted here . Quick installment this time. Left-shift and right-shift operators. Left-shift and right-shift are integral to binary mathematical operations as they have two important qualities: Left-shifting a bitmask once multiplies by two. Read More...
|
-
Originally posted here . It's been longer than I hoped since my last installment on bitmask / big number handling . Life caught up with me and I've had many thankless tasks to catch up on. But that's over now and I'm back to the general slacking that Read More...
|
-
Originally posted here . Posting the first part of my series on bitmasks (yes, this is now officially a series) taught me a lot about my readers: You don't care about handling bitmasks in the database. And I respect you for that! I'm overjoyed, as a matter Read More...
|
-
Originally posted here . In the article on handling bitmasks I posted the other day, I made a fatal error in the splitBitmask function . The function treated the low byte as the first byte, instead of the high byte. Therefore: 0x01 != 0x0001 ... and that Read More...
|
-
Originally posted here . Continuing in my series of things you should probably not do in SQL Server but sometimes have to , I'm going to do a few posts on dealing with very large bitmasks. Let me first state my utter hatered of bitmasks in databases. Read More...
|