Dear author
i do not have the time to read your (well executed but lengthy) treatise in order to find out if it contains value for me (i guess chances...

I am using this same technique in a general SP rendering the output of an SP as HTML.
This cannot be done with OPENQUERY.

found out soumething meanwhile
-  look  in  Activity Monitor if you find something like 'preemptive wait' your  process is waiting for some OS operation to complete. This may last for...

some remarks:
- if you catch it  early enough you are better off killing it
- it seems to be doing it even in  case it is performing just a...

well.what's the benefit - IN NUMBERS - over having an integer PK and an additional index on full email address ?

Hi,
what i am missing in this feature : would like to exclude  columns from versioning , e.g. "last updated" when nothing changes.

question: what is that  WAITFOR DELAY...

After all, what IS Polybase?

Thanks, learned something

just for convenience,

coalesce(object_schema_name(Referencing_ID)+'.','')+ --likely schema name

object_name(Referencing_ID)+ --definite entity name

coalesce('.'+col_name(referencing_ID,referencing_minor_id),'') AS [referencing],

may be written as

concat(object_schema_name(Referencing_ID)+'.', --likely schema name

object_name(Referencing_ID), --definite...

You say using CHARINDEX or PATINDEX for testing for the occurrence of a character string is a bad idea.

that's why i read this article.

Could not find more of an argument...

I wanted a more general approach to make available any JSON for SQL Server, so wrote a CLR to convert any JSON into an XML equivalent, parsing this XML inside...

well, whatever:

pivot column or column being pivoted refers (to my understanding, which you are invited to correct)

to the original column containing the values, whereas the columns resulting from the values...

I do not like the wording. A column HAS a name and CONTAINS values.

so, to my understanding,

'first pivoted column' should be 'first value of pivoted column'

set arithabort off

set ansi_warnings on

declare @i int = 1 / 0

declare @j-2 int = 1

set @j-2 = 1/0

select [@i]=@i , [@j]=@j --> yields @i = NULL,...

It is not true that ANSI WARNINGS OFF generates a result of NULL on zero divide.

Moreover - there is no result generated at all.

What happens is that after...