2021-12-08
625 reads
2021-12-08
625 reads
2021-09-20
676 reads
2020-03-17
727 reads
2021-03-26 (first published: 2018-12-10)
12,829 reads
2018-07-09
1,450 reads
2017-12-11
1,052 reads
Aaron Bertrand rounds out his series on STRING_SPLIT() in SQL Server 2016 with additional tests comparing splitting techniques to TVPs.
2016-06-09
4,804 reads
Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.
2016-05-04
3,767 reads
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
9,094 reads
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. In this article, Aaron Bertrand compares its performance to existing methods.
2016-04-06
4,076 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers