2024-10-16
453 reads
2024-10-16
453 reads
2021-12-08
637 reads
2021-09-20
687 reads
2020-03-17
735 reads
2021-03-26 (first published: 2018-12-10)
13,403 reads
2018-07-09
1,621 reads
2017-12-11
1,068 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,344 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping AS SELECT cl.CityNameID, cl.CityName, o.OrderID, o.Customer, o.OrderDate, o.CustomerID, o.cityId FROM dbo.CityList AS cl INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID GO CREATE OR ALTER FUNCTION GetShipCityForOrder ( @OrderID INT ) RETURNS VARCHAR(50) WITH SCHEMABINDING AS BEGIN DECLARE @city VARCHAR(50); SELECT @city = os.CityName FROM dbo.OrderShipping AS os WHERE os.OrderID = @OrderID; RETURN @city; END; goWhat is the result? See possible answers