Are you registered yet for the Virtual Conference?
Get More Information Here – 70+ sessions, 20+ speakers, 3 days, all directly to your computer.
Webcast: Understanding the new culture of SharePoint
You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we’ll explore change management (the fluffy kind) strategies that can be tailored to your user base. Attract users, and keep your budget!
Presented by: Adam Levithan
> Register Now
> Live date: 7/28/2010 at 12:00 Pacific
Free SharePoint Expo
Are you working with SharePoint? We have GREAT NEWS! We’ve put together our next free expo – it’s for the accidental SharePoint admin! We’re going to have some excellent information for you on things to think about, things you want to keep track of, tips for setting up and converting to SharePoint and a LOT more. “The Accidental SharePoint Admin” is all about the getting you what you need to know, getting you going. Sessions will include help on setting up ground rules for features you want to build and information about moving from a folder-based system like Exchange to the more collaborative environment of SharePoint.The sessions are designed to provide information you can apply today to your own systems –real-world information and examples from top-notch speakers! Sign up today.
[Register here]
Just a Little Bit
How much space does a Bit Column in a table take? It takes at least one Byte…unless…
For some time SQL Server has compacted multiple bit columns into a byte of data reducing the amount of storage required. If you allow null as a third option for your bit column, then an additional null bit is required in the nullable columns bit mask.
So, if you have 8 bit columns it takes one byte to store them. If you have 9-16 bit columns they can be stored in two bytes, and so on. You get the picture.
So the interesting thing that comes out of this is how does the query optimizer handle searching of multiple bits in a single byte? Can it use an index, and if so what would it be? If doing a table scan anyway, does it simply convert the comparison for one or more bit columns into a bitwise and?
Some tools won’t even let you create an index on a bit data type. You can do it in a query window using TSQL. Even then, does the optimizer take an index on a column with two values into consideration? True/False is certainly not very selective.
Ok…if this is getting too deep just tell me to stop. But, if you’re interested, drop a "bit" of a note to btaylor@sswug.org. I’d be interested in the kinds of things you are doing with bit columns, performance issues you may have experienced using them, and optimization techniques you may have discovered.
Cheers,
Ben
Featured Script
dba3_TriggerDemo_SystemUser_HostName_GetDate_Audit
Demonstrates a tamper resistant update audit trigger implementation suitable for single or multiple row updates (and insertio… (read more)