Forum Replies Created

Viewing 15 posts - 46 through 60 (of 102 total)

  • RE: Finding Azure SQL Database

    andrew_dale (10/16/2015)


    answer says

    Row 3 doesn't have a space before, so it does not match.

    but it is actually row 2 that does not have the space before, so row...

  • RE: Filetable Trivia

    Never used Filetables, but isn't the limit to the number of subdirectories subject to the NTFS limit of 2^32 - 1 (4,294,967,295)?

    Therefore the given answer to the question would be...

  • RE: The checksum

    Koen Verbeeck (9/15/2015)


    sipas (9/15/2015)


    PS Not sure what 'his columns are in the wrong order' means - they're in a different order, but how does that affect the ability to use...

  • RE: The checksum

    I might be misunderstanding this, but I thought:

    CHECKSUM will not always return a different result when the values in the expression list change. Therefore it cannot be used to check...

  • RE: MDS Models

    Do models contain the values of entities? I thought the model contained entities, as in their attributes and hierarchies, but the attribute values are in the entity rather than the...

  • RE: Spatial Data Types

    TomThomson (7/7/2015)


    Nice question.

    But is it really CurvedPolygon? I don't think it has a "d".

    +1

  • RE: Insert without a PK

    None of them are correct, but 1, 2 and 4 are either the least incorrect or could be correct if you assume something's missing in the question. But I don't...

  • RE: How Virtualized?

    100% virtual, that includes Oracle as well as SQL. Main reasons - more efficient use of hardware (blade servers and shared storage), easier server management (e.g. varying resources such as...

  • RE: Temp Table Names

    John Mitchell-245523 (4/10/2015)


    sknox (4/10/2015)


    John Mitchell-245523 (4/10/2015)


    Richard Warr (4/10/2015)


    Where it says "116 characters or less" it means "116 characters or fewer" 😉

    I would argue that either is correct. If you...

  • RE: April 1 2015, a space oddity

    Stewart "Arturius" Campbell (4/1/2015)


    sipas (4/1/2015)


    It's also the answer to "What do you get if you multiply six by nine?".

    PS you say "ice cream doesn't have bones", but...

    Happy Easter everybody! 🙂

    actually,...

  • RE: April 1 2015, a space oddity

    It's also the answer to "What do you get if you multiply six by nine?".

    PS you say "ice cream doesn't have bones", but...

    Happy Easter everybody! 🙂

  • RE: CTE Syntax

    TomThomson (3/31/2015)


    Ed Wagner (3/31/2015)


    sipas (3/31/2015)


    Stephanie Giovannini (3/30/2015)


    Instead of inventing the word "beginnator" as the opposite of terminator, how about "initiator"?

    In fact you need to use 'beginninginator' if you want...

  • RE: CTE Syntax

    Stephanie Giovannini (3/30/2015)


    Instead of inventing the word "beginnator" as the opposite of terminator, how about "initiator"?

    In fact you need to use 'beginninginator' if you want to have a chance...

  • RE: CTE Syntax

    Eirikur Eiriksson (3/30/2015)


    ;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.

    😎

    Not terminating T-SQL statements...

  • RE: CTE Syntax

    Koen Verbeeck (3/30/2015)


    Such a bad habit to start a CTE with

    ;WITH

    I hate it 😀

    Nice question though, thanks Steve.

    +1 - maybe part of the answer should be promoting the correct way...

Viewing 15 posts - 46 through 60 (of 102 total)