Interesting .... you must have pushed to hard to educate.

Such a shame ... especially when someone is willing to...

Heh... as with a lot of things, the correct answer is "The MS Documentation on the subject is not clear on this subject".  😉

It reminds me of the documentation on...

Yeah... I was going to suggest that, as well.  Then I remembered how many databases some...

I would like to know the memory consumption distribution(SQL & NON-SQL) at the time the alert occurs. If it is is sql then what within sql is causing it...

ServerName DatabaseName DatabaseSize(MB) Date

Server DBName Size Date
A DB 110 6/1/2023
A DB 113 7/1/2023
A DB 118 8/1/2023
A DB 130 9/1/2023
A DB 120 10/1/2023
A DB 140 11/1/2023
A DB...

Also NNNNIIIIIICCCCCCCEEEEEE!

If I get some time, I try to do some performance tests on the lot tonight.  This is a part of why I love this community!

This is a predominately English speaking forum.  Any chance of you posting the translation for all that instead of us having to run it through a translator?

The JSON will always have the same values/pairs as that part is static.

That pairing is still not 100% as I'm taking suggestions provided by Phil/Steves to help improve the...

Hi All,

I need some assistance and not sure how to achieve the expected output.

I have a JSON input parameter which is a nvarchar(max) passed from my application as per...

Heh... I didn't read the word "rows".

NNNNNNNNNIIIIIIIIICCCCCCEEEEEEE!

@sathishkm-2 - Please explain the business reason for why you need to do this.  Is it in hopes of making a more viable search for a company name?

Ok... shifting gears...

And, no... I wouldn't use a Recursive CTE for this because they're just too expensive for Reads.  A well written WHILE loop is more effective.

What is the Primary key column name and datatype for the table where these company names are stored?

And, are you really using SQL Server 2022?

I have a suggestion... how about having this "developer" document what each section of the code is actually doing in a business sense.  It needs a proper flower box to...