A really interesting question , thanks Umer . But just simple complicated? 😉

DECLARE

@max-2 AS NVARCHAR(MAX) = ''

, @var AS VARCHAR(4000) = 'ABCabc123';-- Varchar instead Nvarchar --

SET @max-2 =...

Useful and interesting question, thank you Steve.

The same result for i may give also this script:

SELECT

MyID

, COUNT(*) OVER (PARTITION BY '') AS i

-- OVER (PARTITION BY '') is the same...

Interesting question, thank you Steve. It reminded me of these two interesting links:

https://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/ and

http://www.sqlbadpractices.com/keeping-maximum-server-memory-default-value/

After all, just something new today for me, thank you Steve. Happy New year to you all.:-)

Marry Christmas and thanks for your work on the SSC.com, Steve.:-)

Jiri Vobr, Czech Republic.

Thanks Steve, may could help also this reference: https://msdn.microsoft.com/en-us/library/ms190806.aspx

Very interesting topic, thank you Dathuraj. Outside references to MSDN, i used this article:

http://blogs.sqlsentry.com/aaronbertrand/t-sql-tuesday-69-always-encrypted-limitations/

A really interesting question. It gave me a hard time :crazy:, but it was worth it. I learned something new and I got it right 🙂

It was unnecessary " to...

Again, a well-refined questions, thanks Hugo .. I had burned on statement X.:crying:

Residual Predicate is well explained in:

https://www.simple-talk.com/sql/learn-sql-server/showplan-operator-of-the-week---merge-join/

Is this modification of your original code a nudge in the right direction?

DECLARE c1 CURSOR READ_ONLY

FOR

SELECT order_no FROM shipping_data

DECLARE @ORDERID char(15),

@myLen Int,

@Result CHAR(3)-- Modification 1 --

OPEN c1

FETCH NEXT FROM c1

INTO...

Thank you Hugo, refined questions very well prepared. It gave me a hard time, but it helped me this article:

http://blogs.sqlsentry.com/aaronbertrand/bad-habits-nolock-everywhere/

Very useful question Eirikur, thank you. 🙂 There is also interesting that COUNT_BIG(*) is here a deterministic function,

because the TOP is not specified with an aggregate clause.

See eg.: ...

Good afternoon Andy, thank you very much for your message and a link to the book.

I will study this book with interest, thanks again and have a nice weekend.

J.V.

Good evening Mr. Andy.

Your cleverly worded questions from the category FileTables according to MSDN documentation

is very difficult to answer . I have a "small" suggestion for you. Please, if...

So this is something new for me, thank you Steve for this very interesting question.