An Overview of STRING_SPLIT()

Learn how to use the STRING_SPLIT() function in T-SQL.

STRING_SPLIT()

STRING_SPLIT with no delimiter

STRING_SPLIT() in SQL Server 2016 : Follow-Up #2

Aaron Bertrand rounds out his series on STRING_SPLIT() in SQL Server 2016 with additional tests comparing splitting techniques to TVPs.

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

Splitting Strings in SQL Server 2016

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods

Performance Surprises and Assumptions: STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. In this article, Aaron Bertrand compares its performance to existing methods.

RE: restore backup versus detach / attach move

You can then reattach your database on the test server. Differences: 1. Size - The backup file may be smaller than the mdf+ldf files which will help the transfer move faster. 2. The time it takes to detach+move+attach could be longer than the time it takes to backup+move+restore. 3. The database is unavailable during the […]

RE: deleting records without writing to transaction log

 >> Correct me if I'm wrong...If you delete a record using the query tool in Enterprise Manager (NOT Query Analyzer) I believe its not logged.  Thats why its so dangerous to mess with data using this too.<< Yep you are not right. It does not depend on the tool. All "delete" operations are logged and in the end EM […]

RE: retreive row from nth row to mth row in table

Hi all,In the BOL for SQL Server 2005 Beta 2 (Yukon) the given example is USE AdventureWorks GO WITH OrderedOrders AS (SELECT SalesOrderID, OrderDate, ROW_NUMBER() OVER (order by OrderDate)as RowNumber FROM Sales.SalesOrderHeader ) SELECT * FROM OrderedOrders WHERE RowNumber between 50 and 60 But when I first meet this question, I solved in the following methodselect * […]