// Behold the New Live Query Stats in SQL Server 2016

featured image Behold the New Live Query Stats in SQL Server 2016 With the release of SQL Server 2016 also comes a great new feature to get a live view of the current execution plan for an active query. This blogpost will cover the aspects of this new feature including: Introduction How to activate How to use and read the output Downsides – if any Introduction The introduction of live query plans are in the current release of SQL Server 2016 CTP 2. [...]

// Multidimensional ROLAP partitions and updatable columnstore indexes – the new black?

featured image Multidimensional ROLAP partitions and updatable columnstore indexes – the new black? I came across a colleague of mine, who asked me if the new updatable columnstore index and ROLAP partitions in a Multidimensional cube is the new trend of fast and no-latency Business Intelligence. Well – here is my 25 cents. I’ll start with the updatable columnstore indexes. With SQL Server 2014 Microsoft introduces updatable columnstore indexes. Which in short terms defines that the columnstore no longer has to be dropped/disabled when loading data to the table. [...]

// SQL 2012: Performance monitoring the light and right way

featured image SQL 2012: Performance monitoring the light and right way Ever had that awesome SQL tracer build up that does just the right thing for your system to do some performance monitoring – well I know that I had. And someday you might need just the same trace again. But now you need to build it again… Here comes the feature Extended Events in place. It was first introduced in the SQL 2008 version. The feature is a good and lightweight event-driven mechanism for collecting information about your SQL server. [...]