Daily Archives: November 17, 2021

STRING_SPLIT Has Ordinals

Posted on November 17, 2021 by way0utwest

I noticed the docs for STRING_SPLIT now show that there is a third parameter. This brings us an ordinal for the positioning of the data. The format is now: STRING_SPLIT( string, separator [, enable_ordinal]) This is a bit or int … Continue reading →

Posted in Blog | Tagged , | 1 Comment

The API Bottleneck

Posted on November 17, 2021 by way0utwest

While talking with a client recently about their performance challenges, I was relieved to find that the database wasn’t the problem. Instead, their API server was overloaded by the number of calls taking place in their application. While the database … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Daily Coping 17 Nov 2021

Posted on November 17, 2021 by way0utwest

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips … Continue reading →

Posted in Blog | Tagged , , | Leave a comment