In todays’ blog posting I want to talk about the memory optimized file group used by In-Memory OLTP to achieve durability, and how to configure it for high performance throughput. Before we go down to the details, I want to give you a brief overview of how In-Memory OLTP achieves durability with this specialized file …
Configuring the In-Memory OLTP File Group for High Performance + read more
Today I’m very happy and proud to announce my brand new SQL Server Query Tuning Workshop that I will run later this year at multiple locations across Europe. The goal of this workshop is very easy: I want to learn you the handcraft how to write better performing T-SQL queries, and how you can analyze …
Today I have uploaded the 14th SQL Server Quickie to YouTube. This time I’m talking about the Tipping Point in SQL Server. Thanks for watching! -Klaus
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 …
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 …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
