Launching Columnstore.NET

I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...

PASS Summit Announcements: Power BI reports on-prem in SSRS

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set...

Reinforcing the Importance of Statistics on Row Estimate

I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...

Ponderings of PASS Summit 2016

Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...

Ponderings of PASS Summit 2016

Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...

SQL Server Backup Compression

I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...

This Week In Data – Episode 11 (Debunking Popular Cloud Myths)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Looking Back: #sqldinner at #sqlsummit 2016

Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...

Live 360–SQL in Orlando

I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...

Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?

*Originally published in our old blog on January 2009

I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...