Pass 1 as the third argument to STRING_SPLIT on SQL Server 2025: `STRING_SPLIT(@list, ',', 1)`. The extra ordinal column lets you ORDER BY it directly instead of adding ROW_NUMBER or trusting input sequence.

Like I l said, it's such a narrow use. I've never encountered that need. I don't deny it exists, but then so do many edge cases. Just seems so obvious to expand it to a specified time limit and beyond QS. It's a bit like v1 of STRING_SPLIT not having the ordinal, but less useful. Many of us told Microsoft about that before release, but weren't listened to. Eventually, the ordinal was added, but it fails under forced parameterization. Slightly depressing all around. Query Governor Cost Limit was never useful or extended as you propose, despite things like Parameter Sensitivity being such a common problem. People want a guarantee on maximum execution time in all sorts of scenarios. No one loves a long running transaction blowing things up (including the version store). Yes, people can write jobs and other monitoring to fix things up in an ad hoc way, but this is an expensive enterprise product we're taking about here, not Postgres or DuckDB. By all means include zero time as an option and make the query hint also available to work in QS, but releasing the feature as-is in a major box release is just embarrassing, frankly. It shows a lack of thought or familiarity with the issues people actually encounter day to day. It's really not good enough. People put up with the lack of investment in e.g. T-SQL because the core engine is strong. This sort of quarter-baked addition undermines that position. Unless some large and loud customer is directly funding this work, I can see no reason to release it in such a limited form.

STRING_SPLIT vs Forced Parameterization: dba.stackexchange.com/q/3439…

This SQL Server STRING_SPLIT bug is really funny to me dba.stackexchange.com/q/3439… 🤣

DuckDB SQL Snippet of the Week 🦆 - string_split There are many string split functions that you can use: • string_split • split_part • string_split_regex TIP: DuckDB indexes start at 1️⃣

Well, that actually just creates a list with a single string element. Don't be fooled by the CLI formatting! What you probably want is something like: string_split('a,b,c', ',');

How to split strings in #SQLServer with STRING_SPLIT function #SQLServer #database #devops #data #bigdata #sql bit.ly/2IyGlG6

Found in a #PowerBI DQ production semantic model. SELECT Col1, Col2, VALUE as Col3, Coln, FROM TableA OUTER APPLY string_split(col3,',') Example only. Was even worse.

A while ago, i came across string_split() in sql and was wondering when i'd ever really have a need for it and here it is. Danny Ma, na you do this one.

Quick Friday post: "Msg 195: STRING_SPLIT is not a recognized built-in function name" tldr, 2 causes of this: 1) Your db compat level is below 130 2) You are calling the function with incorrect syntax. It must be called as a table valued function. catalyzesql.com/blog/2023/08…

Three new features launched today! An `exists` type aggregate, the new `Ash.Type.Keyword`, two new expressions `at/2` and `string_split/3`.

SQL Server 2022 güzel özelliklerle geliyor. -GREATEST () -LEAST () -STRING_SPLIT () -DATETRUNC () -LTRIM () -RTRIM () -TRIM () ve daha fazlası.

Check it out:New post: Should You Use SQL Server 2022’s STRING_SPLIT? sqlservercentral.com/article…

New post: Should You Use SQL Server 2022’s STRING_SPLIT? sqlservercentral.com/article…

Recently Posted, Now with Comments: Should You Use SQL Server 2022’s STRING_SPLIT? brentozar.com/archive/2022/1…

[Blog] Should You Use SQL Server 2022’s STRING_SPLIT? brentozar.com/archive/2022/1…

How to split strings in #SQLServer with STRING_SPLIT function #SQLServer #database #devops #data #bigdata #sql bit.ly/2IyGlG6

SQL Server 👉 La función STRING_SPLIT() devuelve una tabla de una sola columna, 👀 cuyo nombre de columna es value. Esta tabla de resultados contiene filas que son las subcadenas. . . continúa leyendo: bit.ly/3ENzNyd #SQLServer #coding #developer #programador #code

SQL Server – String Functions – STRING_SPLIT() raresql.com/2022/11/28/__tra…

If you've ever had text-delimited data (e.g., "option 1, option 4, option 5" as text in one column), you know how annoying it is. Discovered the handy function string_split() in SQL server today. AND an unusually good tutorial. So, here you go learnsql.com/cookbook/how-to… #scilearn