SQL Server 2016

Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed

Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed

If you are trying to install SQL Server 2016 on Windows Server 2012 R2, under certain circumstances, you might get the below error message: Rule “KB2919355 Installation” failed. KB2919355 Check Failed. If you have installed KB2919355, please make sure you have restarted your machine. For more information, you can visit…

SQL Server 2016: The STRING_SPLIT Function

A long-awaited string function added to SQL Server 2016 is STRING_SPLIT. As the name implies, this function splits the given character expression using the separator set by user. Let’s see some examples of using the STRING_SPLIT function. —–Example #1—DECLARE @string AS VARCHAR(250);SET @string = ‘1-2-3-4-5-6-7-8-9-10’;SELECT  ValueFROM STRING_SPLIT(@string, ‘,’);–Output: —–Example #2—CREATE…

In-Memory OLTP Simulator: The Experiment

A few days ago I published a 38-page technical paper titled “In-Memory OLTP Simulator: The Experiment“. In-Memory OLTP Simulator is a software tool that I developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server. This paper presents a…

In-Memory OLTP Simulator Frequently Asked Questions (FAQ)

What is In-Memory OLTP Simulator?In-Memory OLTP Simulator is third-party tool that allows the user to easily create and run scenarios with different workloads against the In-Memory OLTP Engine of SQL Server®. What is a Simulation Scenario?A simulation scenario is a set of table and stored procedure definitions that generated the…

In-Memory Optimization in SQL Server: Will my Workload Execute Faster?

In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). If I was about to describe this technology in two simple sentences I would do so with the below: It eliminates both locks and latches with…