Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    Revenant (3/14/2014)


    Jeff Moden (3/14/2014)


    TomThomson (3/14/2014)


    jcrawf02 (3/13/2014)


    Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do? I mean,...

  • RE: Today's Random Word!

    JAZZ Master (3/14/2014)


    Ed Wagner (3/14/2014)


    Kurt W. Zimmerman (3/14/2014)


    EricEyster (3/14/2014)


    Revenant (3/14/2014)


    Ed Wagner (3/14/2014)


    BWFC (3/14/2014)


    Paper

    Documentation

    Absent

    vanished

    evaporate

    Milk

    Chocolate

    Fireguard

  • RE: In-Memory OLTP - SQL Server 2014

    Hugo Kornelis (3/14/2014)


    The post you first made about this suggests (at least to me) that delayed durability is a side effect of using in-memory OLTP.

    I certainly didn't intend that....

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/13/2014)


    Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do? I mean, I've never worked with...

  • RE: Are the posted questions getting worse?

    Luis Cazares (3/13/2014)


    rodjkidd (3/13/2014)


    I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%

    A B A C A B

    Just repeat...

  • RE: In-Memory OLTP - SQL Server 2014

    Hugo Kornelis (3/14/2014)


    That page describes the feature "delayed durability", which is added as a new, optional feature in SQL Server 2014.

    This feature is not specifically tied in to in-memory OLTP....

  • RE: In-Memory OLTP - SQL Server 2014

    Hugo Kornelis (3/11/2014)


    TomThomson (3/11/2014)


    It counts as "SCHEMA_AND_DATA" durability but doesn't actually guarantee data durability (it violates the write log first rule of the standard durable transaction model)

    Huh? That's the first...

  • RE: Updating Statistics

    Nice question, I had forgotten that sp_updatestats existed so I got it wrong. Maybe now I'll remember 😉

  • RE: Schema & Renaming Fun

    Amusing question. Since we regularly see statements that the questions, unless they state otherwise, are based on a default US install of a version currently in full support the...

  • RE: Members of windows group

    The call in the explanation doesn't give all memers of the group - members of a group G1 which is itself a member of a group G are automatically members...

  • RE: float vs int

    Grant Fritchey (3/11/2014)


    Store the data in data types that accurately reflect what the data is. Dates go into DATE, date and time go into DATETIME,

    Or, preferably, DATETIME2 - this...

  • RE: In-Memory OLTP - SQL Server 2014

    Nice interesting question.

    The "it depends" answer of course conceals an additional complication - full durability versus delayed durability. It's interesting to think about which side of the...

  • RE: View My Definition

    Hany Helmy (3/7/2014)


    Ford Fairlane (3/6/2014)


    Could have been this or could have been that but we assume the other.... didn't like the question.

    Neither did I.

    Nor did I. Certainly a server...

  • RE: SSIS and Transaction Log Growth

    Nevyn (3/5/2014)


    Koen Verbeeck (3/5/2014)


    Interesting question, but I do not agree entirely with the answer.

    Setting the commit size to a lower value will commit batches before the entire load is done....

  • RE: SSIS and Transaction Log Growth

    Koen Verbeeck (3/5/2014)


    Interesting question, but I do not agree entirely with the answer.

    Setting the commit size to a lower value will commit batches before the entire load is done. What...

Viewing 15 posts - 2,671 through 2,685 (of 7,484 total)