Forum Replies Created

Viewing 15 posts - 121 through 135 (of 825 total)

  • RE: Viewing Plans

    Running the following code raises an error:
    GRANT VIEW SHOWPLAN to JoeDev

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'VIEW'.

  • RE: Collation order by

    It's surprising me!
  • RE: T-SQL sorting

    Toreador - Monday, January 8, 2018 2:01 AM

    Quite interesting I suppose, though the URL in the explanation doesn't state what happens when...

  • RE: SET the results

    The answer is a little confused!
    The statement raises an error, because of incorrect syntax and not because of multiple values assignement. The following statements demonstrate this:
  • RE: Ending 2017

    The 2nd and 3rd answer are equal.
    I'm curious to know why someone chooses the second answer instead of the third or vice versa.
    😀😀😀
  • RE: STRING_SPLIT with no delimiter

    Good to know!
    I would add  a where clause  to avoid empty string
    DECLARE @A VARCHAR(6) = 'ABCDEF'
    SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY) AS VARCHAR),...

  • RE: Data Type Precedence

    Rune Bivrin - Thursday, October 5, 2017 1:05 AM

    Nice one. I got it wrong, simply because I figured adding two dates just...

  • RE: Date fun

    Ahahaha, good fun!

  • RE: Logical Query Processing Filters

    Rune Bivrin - Friday, September 29, 2017 12:04 AM

    Bzzzt!

    Tht's true! I agree.

  • RE: Temporary tables SCOPE

    Christian4143 - Tuesday, September 26, 2017 7:54 AM

    Just to add:

    There is different behavior on SQL-Server 2012....

  • RE: Compressing Integers

    Here the script:

    CREATE TABLE dbo.LotsofIntegers1 (ID INT) WITH (DATA_COMPRESSION = PAGE);
    CREATE TABLE dbo.LotsofIntegers2 (ID BIGINT) WITH (DATA_COMPRESSION = ROW);
    CREATE TABLE dbo.LotsofIntegers3 (ID BIGINT) WITH...

  • RE: When sp_HelpText is not so helpful!

    Another "bug" is when you rename a stored procedure and run sp_helptext.
    It returns the create of stored proc with the old name:
    create procedure A
    as
    select 1 as...

  • RE: Temporary tables SCOPE

    ChrisCarsonSQL - Thursday, September 7, 2017 4:35 PM

    I must be missing something because I tried to execute this SQL and all I...

  • RE: Concurrency in System Versioned Temporal Tables

    Good JOB!
    Thanks!

  • RE: Working for Fun

    We work!
    :-))

Viewing 15 posts - 121 through 135 (of 825 total)