Month: May 2014

Speaking at SQLSaturday #310 in Dublin/Ireland

I’m very proud to announce that I will speak at the SQLSaturday #310 in Dublin. On September 19 I will do a full-day long precon about Performance Tuning Enhancements in SQL Server 2014. I will also present one regular session on Saturday about Plan Caching in SQL Server. Here’s the agenda and the break-down for …

Speaking at SQLSaturday #310 in Dublin/Ireland + read more

Statistics with Ascending Key Column Values

In today’s blog posting I want to talk about a very common problem within SQL Server: handling statistics with ascending key columns. As you already know, every statistics object in SQL Server has an associated Histogram. The histogram describes the data distribution for a specific column with multiple steps. SQL Server supports up to 200 …

Statistics with Ascending Key Column Values + read more