August 2011 - Posts

Office 2010 Helps Me Out

I stink at proof reading. I miss a slew of grammatical and spelling errors. Okay, slew is an understatement.

When I started working heavily with speech technology a few years ago I discovered something interesting. If I used text-to-speech to read what I wrote I caught all the errors. My completely unprofessional diagnosis - my brain is filtering the data stream from my eyes but not my ears. I immediately started using this new trick to improve my proof reading.

The one...
Read More
Posted by MarcLaFleur

SQL Denali Makes Even Fast Look Slow

I’ve seen a lot of performance testing over the years, every so often I’m even impressed a bit by the results. Here is one however that will melt the mind of anyone working against large SQL databases: SQL Denali + 1.4 billion with a b rows = 455x increase from 2008 R2. No, I didn’t fat finger an extra 5 there. It was that big.

How? By using a new feature called a Column Store Index (aka Column Indexing). For those...
Read More
Posted by MarcLaFleur
More Posts