Forum Replies Created

Viewing 15 posts - 796 through 810 (of 7,484 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

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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.

  • 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

  • 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...

  • 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...

  • 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...

  • 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...

  • 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

  • RE: A Load Of Old Cobols

    Accidental duplicate deleted

  • 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...

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