November 22, 2024 at 12:00 am
Comments posted to this topic are about the item New SQL Server 2022 Functions
November 22, 2024 at 2:44 am
GENERATE_SERIES() has a "little" problem for me. I generate shedloads of test data and the following problem means that I'll not be giving up the fnTally function any time soon because I'm sure they'll never fix it.
https://www.sqlservercentral.com/articles/generate_series-breaks-minimal-logging
As for them finally fixing the STRING_SPLIT() function to return the element position ordinals, I'm tickled that they finally got around to it but I cannot believe it took them 3 releases over 6 years to do so.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 22, 2024 at 6:40 pm
A thought on Steve's joke about new functions being actually 2 years old. I imagine a lot of sites that have bigger than average installations of SQL Server that are managed either locally or on a cloud service may not yet be running 2022 yet. I know that's still the situation at my previous employer. I imagine that in the year since I retired plans may be in place to start upgrading to 2022 sooner than later, but it does become a large effort if working on systems that are required to be "always on" for customer use. Thus, it's not too farfetched to think of added functions as "new".
And then I laughed because in the same daily newsletter was an article for SQL Server 2025. With its own set of mouth-watering new goodies. It never ends, I imagine
November 22, 2024 at 7:36 pm
hard to keep up. I laughed at the session, but it makes sense. Lots of people just don't have time (or make time) to check out new things. I should re-run a few "new" things from 2019/2022 as there are likely developers not using them.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy