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

I wish you all a good afternoon.

Answer Query 2 is incorrect because for ADD FILE it is required to enter File option FILENAME.

See syntax checking Query 2: Msg 1036, Level...

Thanks Junior, interesting, but as you can see from the discussion, a bit piquant question.;-)

English is not my native language. So I had translated answer No. 1 that the result...

Thanks Shiva. However I had to translate it twice to Czech. Firstly, what is "Which one of these doesn't match the others?", secondly, what "Who is the odd man out?"....

Thanks Steve. A simple question with unexpected consequences. For me, it was to repeat the lessons about usages of the CONVERT_IMPLICIT functions and the related performance issues.

Thank you for this question. References to this issue opens up wide possibilities for study

issues related to the theme Show Plan.