Ok sweet! Thanks much. I thought that based on what I was looking at that it had something to do with locks/blocks, but couldn't find it. Was that from a...

Try using ShortDateTime with DateTime.Parse. Check this link and see if anything there might help.

http://msdn.microsoft.com/en-us/library/w2sa9yss.aspx

Here's an implementation of the technique described in part 2 written in an ASP.net web project.

http://texastoo.com/post/Implementation-for-Introduction-to-Bitmasking-in-SQL-Server-part-2.aspx

Sweet! Thanks bro

GregoryAJackson (5/22/2009)

---

I agree.

I'm not a fan of this in the world of RDMS's

It's "cool", etc. but it doesnt seem...

Andrew Peterson (5/22/2009)

---

Great article. And nice example use of bitmask for searching.

If you approach the bitmask column for the purpose of high frequency searching, really for "reporting" then...

mike brockington (5/22/2009)

---

I would love to see what this is being compared against, in order to describe this as 'elegant'.

In my dictionary, elegance requires something to be as simple as...

Great point, Leo. For over 64 items you'd have to revert back to the method in part one, or make multiple masks to handle the additional options.

Thanks much

No kidding. And much easier to implement as well. How many times have I written...

Very handy! Good job, here.

Thanks for sharing

Lee

I would just migrate the data out of master and then remove it after your application is back online. No need to rebuild the master database - rebuildm is a...

I've seen this before and started changing out source/destination connection types to find which ones work better. That's not the best answer out here but what I have used when...

Just a shot in the dark...try nvarchar()?

I'd add some service packs as well while you figure this out 🙂

Sounds like something very simple. Create a job to monitor the table via a TSQL query, and send the mail if conditions are (or aren't) met. What I would do...

Another option is that there are several companies that have a "remote dba" services available to handle all of your tasks while you are hiring your new dba. I know...