Forum Replies Created

Viewing 15 posts - 6,301 through 6,315 (of 7,484 total)

  • RE: VLFs in Log Files

    GRE (Gethyn Ellis) (1/19/2011)


    You can't control it directly, But if you follow Kimberely's blog post and Steve's advice , and say growth your transaction log by increments of 8GB, that...

  • RE: Where are you?

    Ray K (1/19/2011)


    Thread's getting quiet again!

    How's the weather where you are?

    Days are sunny but short. Temperature about 14C (57F) at 7am and the same late evening, rising to between...

  • RE: Tempdb

    Nice question, that made me think. I struggled for a while to remember whether there was anything special about tempdb that would preclude chckdb, and then decided that I...

  • RE: Transaction Log Files

    CirquedeSQLeil (1/20/2011)


    Awesome - an easy one every once in a while is great.

    Quite so.

  • RE: @@error

    Nice simple thing. I spent some time looking for the catch though, because strictly speaking none of the answers is correct, since neither of the selects has any outcome...

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/18/2011)


    The easiest way I've found to explain it is to figure out how you can lose. There are three choices, right?

    If you've picked the door with...

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/18/2011)


    Since my degree in Stats was hammered earlier today, here's a classic:

    You are on a game show. There are three doors, behind one of them is...

  • RE: Restore

    Nice easy question, nice clean answer.

    But why on earth is it worth 2 points?

  • RE: UPDATE using a self-join

    CELKO (1/14/2011)


    Tom: MERGE gives an error because it has to by definition. Values in a column are scalars; this is part of First Normal Form. I cannot put multiple scalars...

  • RE: Today's Random Word!

    OCTom (1/14/2011)


    spigot

    dance 😀

  • RE: Today's Random Word!

    CirquedeSQLeil (1/13/2011)


    crookj (1/13/2011)


    WOTD - Office 2010

    Not much of a change from 2007 but still checking it out. Installed it this morning.

    Joe

    Not impressed with 2010 or 2007. They can both...

  • RE: UPDATE using a self-join

    OK, so Merge gives an error message, which is certainly a good thing (it surprised me, because reading the MS documentation I didn't spot that; but with hindsight it doesn't...

  • RE: UPDATE using a self-join

    CELKO (1/13/2011)


    Does the fact that it gives the wrong answers not outweigh your idea of developer ease of reading (which I disagree with).

    Whose idea of developer ease of...

  • RE: UPDATE using a self-join

    GSquared (1/13/2011)


    Jeff Moden (1/12/2011)


    CELKO (1/12/2011)


    Using BIT is bad and a NULL bit makes no sense. Using the proprietary UPDATE..FROM.. syntax has lots of problems with cardinality and portability.

    I don't care...

  • RE: Today's Random Word!

    CirquedeSQLeil (1/13/2011)


    Daniel Bowlin (1/13/2011)


    caffeine

    Caffeinate

    Decaffeinate

Viewing 15 posts - 6,301 through 6,315 (of 7,484 total)