Forum Replies Created

Viewing 15 posts - 1 through 15 (of 521 total)

  • RE: NULL Aggregates

    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...

  • RE: It's Not All About The Keys

    🙁 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"...

  • RE: SQL Server Browser

    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...

  • RE: Dynamic Management Functions

    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...

  • RE: Computed columns Data Types

    Thanks for the question!


    Mighty (11/14/2013)

    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

    What do you mean with that?...

  • RE: Analytical functions available in SQL 2005

    Nice Question, but I dont understand this:

    Before answering the question:

    Analytical functions available in SQL 2005

    By Rob Stebbens, 2013/11/08

    And after answering the question:

    Analytical functions available in SQL 2005

    By Amit...

  • RE: 9002 ERROR

    DOA = Dead on Arrival 😉

  • RE: Parameter sniffing

    Thank you!

  • RE: Disable [guest] database user in [msdb] database

    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"?



    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



    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...

  • RE: TSQL-Order by

    raulggonzalez (7/15/2013)

    It's funny, though, that if you alias the column, both names can be used (original & alias) in the ORDER BY clause

    Try to think of the column alias as...

  • RE: TSQL-Order by

    Thanks for the question

  • RE: Change Tracking

    Thanks for the question

Viewing 15 posts - 1 through 15 (of 521 total)