Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 9,399 total)

  • RE: recursive query to find out orphans

    Luis Cazares (12/2/2016)

    fabriziodb (12/2/2016)

    CELKO (11/30/2016)

    >> I need a query to find out all orphans over a hierarchical table <<

    ``

    I never heard this term before, and I wrote the standards. I...

    December 3, 2016 at 8:30 am

    #1915890

  • RE: Today's Random Word!

    DamianC (12/2/2016)

    Ray K (12/2/2016)

    Ed Wagner (12/2/2016)

    aPed001 (12/2/2016)

    ZZartin (12/2/2016)

    Stuart Davies (12/2/2016)

    Ed Wagner (12/2/2016)

    Kaye Cahs (12/2/2016)

    crookj (12/2/2016)

    aPed001 (12/2/2016)

    Conquer

    Overcome

    Surpass

    Win

    Victor

    Doom

    Bethesda

    Hospital

    M*A*S*H

    hawkeye

    Radar

    December 2, 2016 at 5:14 pm

    #1915869

  • RE: Converting time - from "seconds after midnight"

    Michael L John (12/2/2016)

    Am I missing something, and if not, will this work?

    SELECT CONVERT(varchar(20), CONVERT(time, DATEADD(SECOND, ,<Your field containing seconds>, CONVERT(datetime, CONVERT(date, getdate())))), 100)

    I was thinking along similar lines, but...

    December 2, 2016 at 2:43 pm

    #1915847

  • RE: Setting up SQL Agent Jobs in Alwayson

    Michael John answered the question about jobs in your third topic on the same subject. http://www.sqlservercentral.com/Forums/Topic1839741-391-1.aspx

    December 2, 2016 at 2:31 pm

    #1915842

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/2/2016)

    BWFC (12/2/2016)

    Luis Cazares (12/1/2016)

    Lynn Pettis (12/1/2016)

    For someone who has been "around" SSC as long as "he" has, he sure hasn't changed in all these years.

    I stayed away and...

    December 2, 2016 at 10:50 am

    #1915801

  • RE: Today's Random Word!

    aPed001 (12/2/2016)

    ZZartin (12/2/2016)

    Stuart Davies (12/2/2016)

    Ed Wagner (12/2/2016)

    Kaye Cahs (12/2/2016)

    crookj (12/2/2016)

    aPed001 (12/2/2016)

    Conquer

    Overcome

    Surpass

    Win

    Victor

    Doom

    Bethesda

    Hospital

    December 2, 2016 at 10:48 am

    #1915800

  • RE: Best and economical enterprise monitoring tool

    I have mixed feelings on this topic, but several people have described exactly where I am on it.

    We use SQL Sentry as well. Like Eric said, it's much more...

    December 2, 2016 at 7:23 am

    #1915716

  • RE: Today's Random Word!

    Kaye Cahs (12/2/2016)

    crookj (12/2/2016)

    aPed001 (12/2/2016)

    Conquer

    Overcome

    Surpass

    Win

    December 2, 2016 at 7:15 am

    #1915710

  • RE: Service Broker Message Types

    Koen Verbeeck (12/2/2016)

    Never used service broker. I only know it from the cert exams, so I had to do some research.

    I don't either, so I did as well. There's...

    December 2, 2016 at 6:04 am

    #1915686

  • RE: Communicating with the SQL Browser

    It looks like I wasn't the only one who had to do some research. Thanks for a question that taught me something.

    December 2, 2016 at 6:03 am

    #1915685

  • RE: Today's Random Word!

    djj (12/2/2016)

    DamianC (12/1/2016)

    Manic Star (12/1/2016)

    Ray K (12/1/2016)

    Manic Star (12/1/2016)

    Revenant (12/1/2016)

    djj (12/1/2016)

    Ed Wagner (12/1/2016)

    TomThomson (12/1/2016)

    Ed Wagner (12/1/2016)

    Luis Cazares (12/1/2016)

    djj (12/1/2016)

    aPed001 (12/1/2016)

    Pod

    Pea

    Poe

    Raven

    writing desk

    Chair

    Table

    Index

    Fragmentation

    Defrag

    Fractal

    Recursion

    CTE

    Divide

    December 2, 2016 at 5:57 am

    #1915681

  • RE: Today's Random Word!

    TomThomson (12/1/2016)

    Ed Wagner (12/1/2016)

    Luis Cazares (12/1/2016)

    djj (12/1/2016)

    aPed001 (12/1/2016)

    Pod

    Pea

    Poe

    Raven

    writing desk

    Chair

    December 1, 2016 at 11:33 am

    #1915534

  • RE: Today's Random Word!

    Luis Cazares (12/1/2016)

    djj (12/1/2016)

    aPed001 (12/1/2016)

    Pod

    Pea

    Poe

    Raven

    December 1, 2016 at 9:22 am

    #1915468

  • RE: perform an activity on each database on the server

    It's so they don't have to officially support it. They don't have to guarantee results, MS Connect items aren't addressed and they don't have to maintain BOL. It...

    December 1, 2016 at 7:52 am

    #1915419

  • RE: Today's Random Word!

    Luis Cazares (12/1/2016)

    Grumpy DBA (12/1/2016)

    BWFC (12/1/2016)

    Rover

    Mars

    Chocolate

    Vanilla

    December 1, 2016 at 7:45 am

    #1915415

Viewing 15 posts - 2,161 through 2,175 (of 9,399 total)