Archive | November, 2017

Monitoring the Version Store in SQL Server 2017

14 Nov

Introduction
A couple of years a go I wrote an article about monitoring the version store. With SQL Server 2017 a new DMV has been added to make this easier.
Continue reading →

Tags: , , , , , ,

Compress and Decompress – Basic Examples

1 Nov

Introduction
Whilst reading Itzik Ben Gan’s excellent book on T-SQL I came across the COMPRESS and DECOMPRESS functions. These could be quite useful for some situations that I have, so decided to have a closer look. Continue reading →

Tags: , ,