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.

In SQL Server 2014, for finding number of opened transactions you can still use these two DMVs:

sys.dm_tran_session_transactions, see https://msdn.microsoft.com/en-us/library/ms188739.aspx

sys.dm_exec_sessions, see https://msdn.microsoft.com/en-US/library/ms176013.aspx

In DMV sys.dm_exec_connections is column with number of...

marcia.j.wilson you have true. Here is a simple test:

DECLARE @TrueValue VARCHAR(10);

SET @TrueValue = '';

-----------------------------------------------------------------

SELECT @TrueValue as TrueValue, LEN( @TrueValue) as LenTrueValue

Clever question. Thanks for sharing Naveen.

I wish you all a good afternoon. It is difficult to decide on the correct answer... 🙂

https://technet.microsoft.com/en-us/library/ms179300(v=sql.105).aspx

--==================================================================

USE AdventureWorks2014;-- or AdventureWorks2008R2;

GO

SELECT TOP 10 BusinessEntityID [Employee Identification Number]

FROM HumanResources.Employee;

SELECT TOP 10 BusinessEntityID...

These two randomly selected references describe the issue of add- ins for Excel 2013:

https://support.microsoft.com/en-us/kb/2817425

https://support.microsoft.com/en-us/kb/2805999