Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 9,399 total)

  • RE: newbie ... Avoid subqueries in group by

    Yes, I'd think there should be a much simpler way. This doesn't sound that hard. We need the consumable DDL for the tables, some sample data and expected...

    November 16, 2016 at 5:17 pm

    #1912940

  • RE: Today's Random Word!

    Ray K (11/16/2016)

    Ed Wagner (11/16/2016)

    Manic Star (11/16/2016)

    Luis Cazares (11/16/2016)

    crookj (11/16/2016)

    Y.B. (11/16/2016)

    djj (11/16/2016)

    Ed Wagner (11/16/2016)

    Grumpy DBA (11/16/2016)

    Brandie Tarvin (11/16/2016)

    Removal

    Alien probe

    X Files

    X Men

    Mutants

    Inhumans

    S.H.I.E.L.D.

    H.Y.D.R.A.

    Quantico

    F.B.I.

    CIA

    November 16, 2016 at 5:07 pm

    #1912939

  • RE: com.microsoft.sqlserver.jdbc.SQLServerException: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

    Is it my imagination, or are you firing INSERTs in a loop against the same table the trigger is firing on? You have a cursor inside your trigger that's...

    November 16, 2016 at 12:11 pm

    #1912901

  • RE: Today's Random Word!

    Manic Star (11/16/2016)

    Luis Cazares (11/16/2016)

    crookj (11/16/2016)

    Y.B. (11/16/2016)

    djj (11/16/2016)

    Ed Wagner (11/16/2016)

    Grumpy DBA (11/16/2016)

    Brandie Tarvin (11/16/2016)

    Removal

    Alien probe

    X Files

    X Men

    Mutants

    Inhumans

    S.H.I.E.L.D.

    H.Y.D.R.A.

    Quantico

    November 16, 2016 at 11:27 am

    #1912888

  • RE: Temp tables in transaction

    There are all kinds of interesting tidbits about table variables and temp tables. Wayne Sheffield has a great presentation on them that I really enjoyed. I'd recommend attending...

    November 16, 2016 at 11:27 am

    #1912886

  • RE: Are the posted questions getting worse?

    GilaMonster (11/16/2016)

    For everyone here, if you can, watch the keynote of https://connectevent.microsoft.com/, starting in the next few minutes. There are reasons.

    I won't be able to watch the whole thing, but...

    November 16, 2016 at 8:01 am

    #1912802

  • RE: Today's Random Word!

    Grumpy DBA (11/16/2016)

    Brandie Tarvin (11/16/2016)

    Removal

    Alien probe

    X Files

    November 16, 2016 at 6:27 am

    #1912765

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (11/16/2016)

    --Warning Food discussion starting--

    One of my favorite ways to enjoy gorgonzola is to add it to a sauce pan with about the same amount of heavy cream. Then...

    November 16, 2016 at 5:31 am

    #1912755

  • RE: Today's Random Word!

    djj (11/16/2016)

    DamianC (11/16/2016)

    Brandie Tarvin (11/15/2016)

    Y.B. (11/15/2016)

    Luis Cazares (11/15/2016)

    Ed Wagner (11/15/2016)

    djj (11/15/2016)

    Manic Star (11/15/2016)

    djj (11/15/2016)

    Ed Wagner (11/15/2016)

    BWFC (11/15/2016)

    Click

    Link

    Missing

    Dog

    Cat

    Mouse

    Cheese

    Swiss

    CHEDDAR (is better)

    Crackers

    Explosion

    Shrapnel

    November 16, 2016 at 5:27 am

    #1912753

  • RE: Temp tables in transaction

    Good question, Sergiy. Thanks.

    November 16, 2016 at 5:25 am

    #1912751

  • RE: Disk space report

    Eirikur Eiriksson (11/16/2016)

    ramyours2003 (11/16/2016)

    We need to collect the disk space utilization on weekly basis and we have 50+ servers . I need a report of all the servers how...

    November 16, 2016 at 5:22 am

    #1912750

  • RE: Today's Random Word!

    Kaye Cahs (11/15/2016)

    Grumpy DBA (11/15/2016)

    Ray K (11/15/2016)

    crookj (11/15/2016)

    Ed Wagner (11/15/2016)

    Luis Cazares (11/15/2016)

    Hugo Kornelis (11/15/2016)

    Lucy

    Fossil

    Skeleton

    Teeth (of the Hydra)

    Dentist

    Hermie

    Bumble

    Bee

    November 15, 2016 at 1:57 pm

    #1912663

  • RE: Today's Random Word!

    Luis Cazares (11/15/2016)

    Hugo Kornelis (11/15/2016)

    Lucy

    Fossil

    Skeleton

    November 15, 2016 at 12:26 pm

    #1912639

  • RE: Today's Random Word!

    Hugo Kornelis (11/15/2016)

    Brandie Tarvin (11/15/2016)

    djj (11/15/2016)

    Ed Wagner (11/15/2016)

    Revenant (11/15/2016)

    Ed Wagner (11/15/2016)

    Brandie Tarvin (11/15/2016)

    Y.B. (11/15/2016)

    Luis Cazares (11/15/2016)

    Ed Wagner (11/15/2016)

    djj (11/15/2016)

    Manic Star (11/15/2016)

    djj (11/15/2016)

    Ed Wagner (11/15/2016)

    BWFC (11/15/2016)

    Click

    Link

    Missing

    Dog

    Cat

    Mouse

    Cheese

    Swiss

    CHEDDAR (is better)

    Sharp

    Electronics

    Circuit

    Board

    Mother

    Should I trust the...

    November 15, 2016 at 11:13 am

    #1912619

  • RE: Are the posted questions getting worse?

    Y.B. (11/15/2016)

    Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

    That being said I did recently try an Irish Cheddar which was excellent. I like...

    November 15, 2016 at 11:12 am

    #1912618

Viewing 15 posts - 2,251 through 2,265 (of 9,399 total)