Many excellent points being made here. It seems that the main points in favor of embedded SQL / ORM are:

1. developer efficiency / convenience (size of the team, and if...

• This reply was modified 4 years, 8 months ago by  Solomon Rutzky.

Update:  I just read the link in Steve's editorial:  https://sqlquantumleap.com/2018/09/28/native-utf-8-support-in-sql-server-2019-savior-false-prophet-or-both/  There is a lot of good information in there.  It looks like the UTF-8 collation is case...

Hi there. In its current form, that post contains several technical...

Hi Ronald. Great job sticking with not enabling TRUSTWORTHY, and figuring out how to accomplish that!

Just one error I noticed in the article that should probably be updated to be...

• This reply was modified 4 years, 10 months ago by  Solomon Rutzky.

Here is my post on this topic:

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

Take care,

Solomon..

OK - I'm missing something or misunderstanding the point, because SELECT 1 or SELECT * works fine for a user that is denied permission on a column within the...

• This reply was modified 4 years, 10 months ago by  Solomon Rutzky.

Did you miss a big point?  There is actually a very good reason to name a specific column!If you don't have access to every single column in the...

Hi Steve. If you want more...

• This reply was modified 4 years, 11 months ago by  Solomon Rutzky.
• This reply was modified 4 years, 11 months ago by  Solomon Rutzky.

Regarding @jonathan-ac-roberts 's test: you might want to include a GO between the two test queries. It might not make a difference, but I have found...

having something that has a varchar passed to it that returns an nvarchar could be very bad for SARGability, if the column being compared afterwards is a varchar...

• This reply was modified 4 years, 11 months ago by  Solomon Rutzky.
• This reply was modified 4 years, 11 months ago by  Solomon Rutzky.

Hi there. Interesting concept, but some questions:

1. What is the practical usage of this approach? Once you have the collection of INTs in the Geometry type, how do you use...

• This reply was modified 5 years ago by  Solomon Rutzky.

For my test (immediately) above, I used double-backslashes outside of the code block because that seemed to work for O.P. The tests seem to indicate that within a code block,...

• This reply was modified 5 years ago by  Solomon Rutzky.

SIMPLE TEST

This is a test\of line continuation (outside of a code block)

This is a testof line continuation (inside a code block)

SPACE AFTER BACKSLASH TEST

This is a...

Are you really using the same SQLCLR TVF for countries and states, or is that just a copy/paste issue when typing up the question? SQLCLR TVFs always report to the...

• This reply was modified 5 years ago by  Solomon Rutzky.

Hi Thomas. Interesting question. A few notes:

1. Most importantly, there is a typo in the setup code, implying that the answer should be the opposite of what it really is....

• This reply was modified 5 years ago by  Solomon Rutzky.