Forum Replies Created

Viewing 15 posts - 796 through 810 (of 7,483 total)

  • RE: Today's Random Word!

    ZZartin (11/10/2016)


    Ed Wagner (11/10/2016)


    Grumpy DBA (11/10/2016)


    djj (11/10/2016)


    Beer

    Goggles

    Diving

    Stage

    Fright

    Tom

  • RE: INSERTing datetimeoffsets

    Steve Jones - SSC Editor (11/3/2016)


    Clearly I edited an answer somewhere, causing issues. It's certainly my fault. Our interface makes checking these items hard, so I have to be extra...

    Tom

  • RE: Case Statement Update

    MMartin1 (11/8/2016)


    Koen Verbeeck (11/8/2016)


    Somehow completely missed that the data type was bit.

    Moar caffeine needed!

    Ok maybe the defaulting of the bit field to 'false' is a little "bit" tricky. Part of...

    Tom

  • RE: Adding Temporal Support

    Interesting question. Of course there should be no need to hide the columns unless the existing apps are using "*" instead of "<columnlist>".

    Adding the extra columns with defaults...

    Tom

  • RE: Dropping Audit Sessions

    Steve Jones - SSC Editor (10/31/2016)


    My mistake. I checked the wrong box. I'll award back points.

    The audit spec is separate from the audit itself. You do need to stop/disable the...

    Tom

  • RE: Concatenate and conatenatex

    Nice question, but I think the explanation of concatenatex is a bit off - the elements that get concatenated are the results of evaluating the expression parameter on every row...

    Tom

  • RE: Which Time Zone?

    Koen Verbeeck (10/25/2016)


    Ugh. I hate time zones 😀

    I don't actually hate time zones, but I do hate MS's hopelessly misleading names for some of them.

    Tom

  • RE: Today's Random Word!

    Ray K (10/24/2016)


    djj (10/24/2016)


    Grumpy DBA (10/24/2016)


    Luis Cazares (10/24/2016)


    ZZartin (10/24/2016)


    Face

    Book

    Picture

    Image

    JPEG

    SGVIII

    Tom

  • RE: Let the shell free

    Jeff Moden (10/23/2016)


    The correct answer is only a 1/4 correct. You also have to enable advanced options and RECONFIGURE twice (once for the advanced options and once to enable...

    Tom

  • RE: Which Time Zone?

    Ed Wagner (10/21/2016)


    TomThomson (10/21/2016)


    BillLudlow (10/18/2016)


    Sorry didn't like that one Steve, totally unfamiliar with the AT TIME ZONE command, and of course I got it wrong.

    Doh!

    Me too. I thought SQL...

    Tom

  • RE: The Backup Operator

    Interesting. Good question.

    I thought that might be how it is, but was unsure because the permission is assigned to a database user, not to a login, so read...

    Tom

  • RE: Which Time Zone?

    BillLudlow (10/18/2016)


    Sorry didn't like that one Steve, totally unfamiliar with the AT TIME ZONE command, and of course I got it wrong.

    Doh!

    Me too. I thought SQL Server would assume...

    Tom

  • RE: Today's Random Word!

    Ed Wagner (10/21/2016)


    HappyGeek (10/21/2016)


    djj (10/21/2016)


    Luis Cazares (10/21/2016)Mouse

    Mickey

    Minnie

    Cooper

    Barrel

    Tom

  • RE: A Load Of Old Cobols

    Accidental duplicate deleted

    Tom

  • RE: A Load Of Old Cobols

    David.Poole (10/17/2016)


    I was aghast to find an old Clipper app still being maintained, although it didn't really need much maintaining. For next to no investment it was cheerfully generating...

    Tom

Viewing 15 posts - 796 through 810 (of 7,483 total)