Conor vs. Windows 7

(Not a SQL Server post) I have been meaning to install Windows 7, and I got around to doing it last night.  I usually run Windows 2003/8 Server for work, so my interest in the consumer side is perhaps not as high as some others.  Nevertheless, I like Windows and I wanted to try it…

0

Conor vs. UNIQUE in Index Definitions

I gave a talk to the Austin-area PASS group last night on B-Tree indexing in SQL Server, and I received a question about whether to make clustered indexes UNIQUE or not (assuming the data is unique on the key columns).  The expectation was that this should perform better when the index was UNIQUE. Let’s back…

1