Daily Archives: November 17, 2021

STRING_SPLIT Has Ordinals

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

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

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