Transaction Commit latency acceleration using Storage Class Memory in Windows Server 2016/SQL Server 2016 SP1

SQL Server 2016 SP1 adds a significant new performance feature, the ability to accelerate transaction commit times (latency) by up to 2-4X, when employing Storage Class Memory (NVDIMM-N nonvolatile storage). This scenario is also referred to as “persistent log buffer” as explained below. This enhancement is especially valuable for workloads which require high frequency, low… Read more

Introducing Batch Mode Adaptive Memory Grant Feedback

SQL Server uses memory to store in-transit rows for hash join and sort operations. When a query execution plan is compiled for a statement, SQL Server estimates both the minimum required memory needed for execution and the ideal memory grant size needed to have all rows in memory.  This memory grant size is based on… Read more

Columnstore Index: Standard and Express editions with SQL Server 2016 SP1

I am sure you all have heard the exciting news that SQL Server 2016 SP1 supports Common Programming Surface Area (CPSA) across all features. And, YES, that includes columnstore index. Please refer to the following blog for details Columnstore Index: Standard and Express editions with SQL Server 2016 SP1 Thanks Sunil Agarwal and Kevin Farlee  … Read more

In-Memory OLTP in Standard and Express editions, with SQL Server 2016 SP1

We just announced the release of Service Pack 1 for SQL Server 2016. With SP1 we made a push to bring a consistent programming surface area across all editions of SQL Server. One of the outcomes is that In-Memory OLTP (aka Hekaton), the premier performance technology for transaction processing, data ingestion, data load, and transient… Read more

CREATE OR ALTER – another great language enhancement in SQL Server 2016 SP1

We are happy to announce that SQL Server 2016 SP1 and SQL Server v.Next have new T-SQL language statement – CREATE [OR ALTER]. This statement combines CREATE and ALTER statements and creates object if it does not exist, or alter it if it is already there. CREATE OR ALTER can be applied on the following… Read more

Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics?

Please refer to this blog under MSSQL Tiger Team blog site   Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics? Thanks Sunil Agarwal… Read more

SQL Server 2016 Express Edition in Windows containers

We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our SQL Server Samples GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers. SQL Server… Read more