Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 9,399 total)

  • RE: calculating time difference

    JALLYKAMOZE (8/30/2016)


    Hello,

    I have a problem where i want to get the diffrence in minutes between two times, my datatype is TIME, i have also used the function below

    ABS(DATEDIFF (MINUTE,...

  • RE: Conversion failed when converting date and/or time from character string.

    Once you get the data type precedence (stated above) figured out, you'll probably want to format both of those dates so they display in the same format. Whatever you...

  • RE: Today's Random Word!

    TomThomson (8/30/2016)


    Ed Wagner (8/30/2016)


    Grumpy DBA (8/30/2016)


    ThomasRushton (8/30/2016)


    djj (8/30/2016)


    Ed Wagner (8/30/2016)


    TomThomson (8/30/2016)


    Kaye Cahs (8/29/2016)


    Hunt

    Down

    Town

    Our (Town - play by Wilder)

    House (in the middle of Our Street)

    Madness

    Play (Iron Maiden Reference)

    Amphitruo(the play)

    Amphitheater

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/30/2016)


    Ed Wagner (8/30/2016)


    Brandie Tarvin (8/30/2016)


    rodjkidd (8/30/2016)


    Interviews...

    I've had few fun ones over the years. Normally on the non technical side.

    But I was once asked what are the three tables...

  • RE: DDL and TRANSACTIONS

    Luis Cazares (8/30/2016)


    The DDL and transaction myth might come from Oracle and deformed badly. Hopefully, the myth that DDL is not affected by transactions will be gone eventually.

    That's likely where...

  • RE: Are the posted questions getting worse?

    Ray K (8/30/2016)


    Ed Wagner (8/30/2016)


    Brandie Tarvin (8/30/2016)


    rodjkidd (8/30/2016)


    Interviews...

    I've had few fun ones over the years. Normally on the non technical side.

    But I was once asked what are the three tables...

  • RE: SQL Login keeps losing access to databases

    Sean Perkins (8/30/2016)


    Sean now understands!

    I thank you and greatly appreciate both of you for taking the time to help me and explain how this works.

    I assure you this is a...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/30/2016)


    rodjkidd (8/30/2016)


    Interviews...

    I've had few fun ones over the years. Normally on the non technical side.

    But I was once asked what are the three tables you can access in...

  • RE: Today's Random Word!

    Grumpy DBA (8/30/2016)


    ThomasRushton (8/30/2016)


    djj (8/30/2016)


    Ed Wagner (8/30/2016)


    TomThomson (8/30/2016)


    Kaye Cahs (8/29/2016)


    Hunt

    Down

    Town

    Our (Town - play by Wilder)

    House (in the middle of Our Street)

    Madness

    Play (Iron Maiden Reference)

  • RE: SQL Login keeps losing access to databases

    Building on what Lynn said, for SQL logins, the start of authority is the instance, so that's used to build the SID. A different server will have a different...

  • RE: DDL and TRANSACTIONS

    TomThomson (8/30/2016)


    Good straightforward question.

    It's a bit disturbing that about a third of answers so far are wrong on someting as fundamental as this.

    Agreed, but there was another QOTD recently that...

  • RE: tempdb default directories SQL 2016

    Thanks, Steve. It'll be a few years before we get 2016 I'm sure, but it's nice to learn what I can before we get it.

  • RE: Today's Random Word!

    TomThomson (8/30/2016)


    Kaye Cahs (8/29/2016)


    Hunt

    Down

    Town

  • RE: Today's Random Word!

    Luis Cazares (8/29/2016)


    Hugo Kornelis (8/29/2016)


    Ed Wagner (8/29/2016)


    Ray K (8/29/2016)


    djj (8/29/2016)


    Hugo Kornelis (8/29/2016)


    Ed Wagner (8/29/2016)


    crookj (8/29/2016)


    djj (8/29/2016)


    Ed Wagner (8/27/2016)


    TomThomson (8/26/2016)


    Grumpy DBA (8/26/2016)


    whereisSQL? (8/26/2016)


    Explode

    Implode

    Collapse

    Fall

    Trip

    ACID (and no - this is not about SQL)...

  • RE: Today's Random Word!

    Ray K (8/29/2016)


    djj (8/29/2016)


    Hugo Kornelis (8/29/2016)


    Ed Wagner (8/29/2016)


    crookj (8/29/2016)


    djj (8/29/2016)


    Ed Wagner (8/27/2016)


    TomThomson (8/26/2016)


    Grumpy DBA (8/26/2016)


    whereisSQL? (8/26/2016)


    Explode

    Implode

    Collapse

    Fall

    Trip

    ACID (and no - this is not about SQL) :hehe:

    Pink Floyd

    Careful with that axe,...

Viewing 15 posts - 2,641 through 2,655 (of 9,399 total)