Hugo Kornelis (1/7/2015)

---

Got the answer by deduction and removing the obvious wrongs ones, but I do not like the question.

COUNT, as any other aggregate, ignores NULL values.

COUNT(*) is special. The...

🙁 I had guessed that this was a question about case sensitivity and "duplicate" rows that only differ in case (e.g. Master vs. master). I also assumed the table "databases"...

Yes, the question is a little ambiguous, but that has no impact on the answer, since the service itself is not listed as an option (with no switches).

Definitively not a...

For SQL Server 2008 R2 there is no valid answer, as sys.dm_exec_sessions does not contain the open tran count. But thanks to this, I have learned that this column is...

Thanks for the question!

What do you mean with that?...

Nice Question, but I dont understand this:

Before answering the question:

And after answering the question:

Analytical functions available in SQL 2005

By Amit...

DOA = Dead on Arrival 😉

Thank you!

sknox (9/23/2013)

---

So if you don't need the features that rely on guest access, you can disable it in msdb?

So the correct answer should be "It depends on the security requirements"?

The...

PHYData DBA (8/1/2013)

---

DECLARE @var money = 123456789101118.12345

DECLARE @varchar nvarchar(35)

DECLARE @char nchar(22)

--Select 1

SELECT LEN('123456789101118.12345'), DATALENGTH('123456789101118.12345') ,'123456789101118.12345'

--Select 2

SELECT LEN(@var), DATALENGTH(@var), @var

--Select 3

SELECT @varchar = convert(nvarchar(25), @var)

SELECT LEN(@varchar), DATALENGTH(@varchar), @varchar

--Select...

john.arnott (7/31/2013)

---

L' Eomot Inversé (7/30/2013)

---

...... The question is about the lengths of the strings to which the numeric values are implicitly converted, since the length operator used is...

Try to think of the column alias as...

Thanks for the question

Thanks for the question