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.

I was wrong. Evidently I did not read this article carefully:

https://www.simple-talk.com/sql/backup-and-recovery/centralized-management-tips-for-managing-backups-on-multiple-servers/

Thank you for your question , it's new lesson for me and it guided me even to the Selective XML indexes.

Thanks Steve.

I had to once again repeat the DateDiff and DateAdd functions 😉

Merry Christmas 2014 and Happy New Year 2015.

I will get an error like this: Server: Msg 208, Level 16, State 1, Procedure my_sp, Line 2 Invalid object name 'my_table'.