SQL Server

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…

The transaction log for database ‘dbname’ is full due to ‘XTP_CHECKPOINT’‏

When using In-Memory OLTP in SQL Server 2014, under certain conditions you might get the below error message: The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’‏  This was fixed in Cumulative Update 3 for SQL Server 2014 SP1 More information about the fix can be found here.