Hewlett Packard Enterprise Persistent Memory

Hewlett Packard Enterprise (HPE) has announced a new product that uses non-volatile DIMMs (NVDIMMs), which they are calling Persistent Memory. This short video gives a high level view of how it works, via a whiteboard time lapse. The initial product is an 8GB module which has 8GB of DRAM backed by 8GB of flash for […]

Eight Different Ways to Clear the SQL Server Plan Cache

Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you usually get some sort of a scary warning about how you should not use it on a production system, or else life as we know it will end. For example, Books Online says this: Use DBCC FREEPROCCACHE […]

SQL Server 2012 Service Pack 3 CU2 Available

On March 21, 2016, Microsoft released SQL Server 2012 Service Pack 3 CU2, which is Build 11.0.6523.0. This Cumulative Update has 20 hotfixes in the Public fix list, which is a relatively low number for a SQL Server 2012 Cumulative Update. If you are running SQL Server 2012, I think you should be moving to […]

SQL Server Diagnostic Information Queries for March 2016

This month, I have one new query in the SQL Server 2016 set, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. Rather than having a separate blog post for each version, I have just put the links for all six major versions in this single post. There are […]

New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014

There are two new TPC-H benchmark submissions on SQL Server 2016. This is interesting, because one of these new submissions (from March 9, 2016) is from Lenovo, for a System x3850 X6 running on SQL Server 2016. Lenovo has a previous submission, from May 1, 2015, for an identical model system running on SQL Server […]

SQL Server Countdown

Microsoft is putting out some silly, but funny videos to promote their Data Driven Event on March 10, 2016 at 10AM EST. The very short videos have a collection of well-known Microsoft employees, and other SQL Server notables, such as our own Kimberly Tripp, being “blown away” as Microsoft SQL Server 2016 goes supersonic. You […]

Using ALTER DATABASE SCOPED CONFIGURATION in SQL Server 2016

On March 7, 2016, Microsoft announced the availability of the RC0 Build of SQL Server 2016. One of the new features in the RC0 Build is Database Scoped Configurations, which gives you the ability to easily make several database-level configuration changes for things that were previously configured at the instance-level. These include: Setting MAXDOP for […]