Daily Archives: June 23, 2011

Setting a Unique Index on a Bit Field

Can you set a unique index on a bit field? Well, you can, but you’d end up with a very short table of two (or three) rows. I defined this table: CREATE TABLE [dbo].[BitTest]( [MyBit] [bit] NULL, [MyName] [varchar](50) NULL … Continue reading

Posted in Blog | Tagged , | Comments Off on Setting a Unique Index on a Bit Field

The Age of Software

Does the age of software matter? It’s an interesting question and one which recently came to my attention after a blog post by Dan Jones. Dan works on the SQL Server team and posted a note that the SQL 11 … Continue reading

Posted in Editorial | Tagged | Comments Off on The Age of Software