Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 7,484 total)

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    Jeff Moden (4/25/2014)


    Actually, while I'm here...

    If I'm reading the code correctly, the code has a bit of a flaw in it that you might want to consider. If someone...

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    dba.sql29 (4/25/2014)


    Thank you for this DML trigger.

    When I am running this trigger I am getting syntax error is there any thing I need to change in that trigger ?

    There shouldn't...

  • RE: Today's Random Word!

    BWFC (4/25/2014)


    Stuart Davies (4/25/2014)


    crookj (4/25/2014)


    TomThomson (4/25/2014)


    Ed Wagner (4/25/2014)


    BWFC (4/25/2014)


    crookj (4/23/2014)


    Ed Wagner (4/23/2014)


    Revenant (4/23/2014)


    Ed Wagner (4/23/2014)


    SQLRNNR (4/23/2014)


    periwinkle

    Bullwinkle

    Rocky

    Stallone

    Rambo

    Prism

    Edit Stuart beat me to it again

    Light

    weight

    refract (light)

    Reflect

    Ponder

    Contemplate

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/24/2014)


    rodjkidd (4/23/2014)


    Hope the op and recovery go well. You gotta make it over for SQL Bits.

    Rodders...

    On the shed-dyule for Bits, and planning on it. Can't...

  • RE: Today's Random Word!

    Ed Wagner (4/25/2014)


    BWFC (4/25/2014)


    crookj (4/23/2014)


    Ed Wagner (4/23/2014)


    Revenant (4/23/2014)


    Ed Wagner (4/23/2014)


    SQLRNNR (4/23/2014)


    periwinkle

    Bullwinkle

    Rocky

    Stallone

    Rambo

    Prism

    Edit Stuart beat me to it again

    Light

    weight

  • RE: AlwaysOn 2014

    Interesting question.

    I found the wrong answer in BOL: (the SQL server 2014 version of) Overview of AlwaysOn Availability Groups (SQL Server) states that 2014 supports only 4 secondary replicas (plus...

  • RE: Memory-Optimized Table Disk space

    I suspect this 2 times is only a rough estimate, as it appears to be directly contradicted by the BOL page Durability for Memory-Optimized Tables which states

    BOL


    Storage taken by...

  • RE: Double Keys

    Good question, Something that has to be understood in order to have properly compartmentalised access.

    Interesting that each of the two necessary actions was included in more than half of...

  • RE: Azure Data Files

    AArgh!! I hadn't noticed that feature of 2014 yet, so I answered wrong.

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (4/20/2014)


    Bucket List Challenge - teach Jim to Filet a fish properly.

    I'll keep trying, but I may fail miserably.

    Fillet "a fish" is not a good test. I can...

  • RE: Today's Random Word!

    SQLRNNR (4/20/2014)


    Revenant (4/19/2014)


    TomThomson (4/19/2014)


    rhythmk (4/19/2014)


    Ed Wagner (4/18/2014)


    Revenant (4/18/2014)


    BWFC (4/18/2014)


    crookj (4/17/2014)


    Ed Wagner (4/17/2014)


    SQLRNNR (4/17/2014)


    pretense

    assumption

    postulation

    Theory

    Science

    Thought

    Concept

    idea

    horse

    with no name

    no pain

  • RE: Today's Random Word!

    rhythmk (4/19/2014)


    Ed Wagner (4/18/2014)


    Revenant (4/18/2014)


    BWFC (4/18/2014)


    crookj (4/17/2014)


    Ed Wagner (4/17/2014)


    SQLRNNR (4/17/2014)


    pretense

    assumption

    postulation

    Theory

    Science

    Thought

    Concept

    idea

  • RE: Query optimization help

    Lynn Pettis (4/18/2014)


    TomThomson (4/17/2014)


    I may be confused here, but if I've understood correctly the optimiser might be able to do somewhat better with an index like this:-

    CREATE NONCLUSTERED INDEX [AI_OperatorCBGEstimate_14947]...

  • RE: SSMS Results

    Very clear and easy question.

    The page referenced in the explanation is another example of BOL getting it wrong - it says the default keyboard scheme is the VS 2010...

  • RE: Need a logic

    I like the solution above from gbritton1, but nother way of doing which is probably less efficent but perhaps also easier to understand would be

    select m.description from @message m

    ...

Viewing 15 posts - 2,596 through 2,610 (of 7,484 total)