SQL Server 2016

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)

Please read below for 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…