Forum Replies Created

Viewing 15 posts - 331 through 345 (of 3,348 total)

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Jeff Moden (10/7/2016)


    Hugo Kornelis (10/7/2016)


    Jeff Moden (10/7/2016)


    Hugo Kornelis (10/7/2016)


    You could wrap the fast but unreliable method ...

    Heh... maybe for you but it's never been unreliable for me. You must...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Jeff Moden (10/7/2016)


    Hugo Kornelis (10/7/2016)


    You could wrap the fast but unreliable method ...

    Heh... maybe for you but it's never been unreliable for me. You must be doing something wrong....

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    lbnayak (10/6/2016)


    The concept is to chain records together in a linked list fashion with hashvalue from 'a previous record' stored in the 'next record' as a means to detect...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    lbnayak (10/6/2016)


    On my test box on MS SQL2012 I find it is running in exactly opposite order to the clustered index & I suspect in random order. Here...

  • RE: Are the posted questions getting worse?

    drew.allen (10/5/2016)


    Hugo Kornelis (10/5/2016)


    drew.allen (10/5/2016)


    With my first article for SSC accepted for publishing, I've already written a second (unrelated) article. I'd like to have a couple of people review...

  • RE: Are the posted questions getting worse?

    drew.allen (10/5/2016)


    With my first article for SSC accepted for publishing, I've already written a second (unrelated) article. I'd like to have a couple of people review it.

    What is the...

  • RE: Recommendation for better perfromance

    ramyours2003 (10/5/2016)


    what is the reason of not creating index on 32 bit system?

    Eeuhhhmm ... perhaps someone WANTS bad performance?

    More serious: some third party application have a rule in the license...

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (10/2/2016)


    BLOB_EATER (10/2/2016)


    Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).... Im scared.

    Don't be scared...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/29/2016)


    But, most of my 'jokes' are on-the-fly, not rehearsed, based on the feel in the room. Don't plan to put jokes into a specific point of a presentation just...

  • RE: Are the posted questions getting worse?

    BLOB_EATER (9/29/2016)


    so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

  • RE: Today's Random Word!

    Ed Wagner (9/28/2016)


    whereisSQL? (9/28/2016)


    crookj (9/28/2016)


    Ed Wagner (9/28/2016)


    djj (9/28/2016)


    TomThomson (9/27/2016)


    whereisSQL? (9/27/2016)


    djj (9/27/2016)


    Ed Wagner (9/27/2016)


    djj (9/27/2016)


    Ed Wagner (9/27/2016)


    whereisSQL? (9/27/2016)


    Revenant (9/27/2016)


    djj (9/27/2016)


    Ed Wagner (9/27/2016)


    ThomasRushton (9/27/2016)


    Grumpy DBA (9/27/2016)


    Ray K (9/26/2016)


    Manic Star (9/26/2016)


    Saul

    Tigh

    Colonel

    Mustard

    Seed

    Weed

    Need

    Want

    Always

    Nevermore

    Evermore (Heroes Reborn...

  • RE: Today's Random Word!

    ThomasRushton (9/23/2016)


    TomThomson (9/23/2016)


    Stuart Davies (9/23/2016)


    Jeff Moden (9/22/2016)


    Delivery

    Van

    Front

    Line

    Flatworld

  • RE: SQL anaylsis

    MMartin1 (9/15/2016)


    Just wanted to bring up a point of inquiry : the view sys.dm_db_index_usage_stats would not satisfy if any table has no indeces I imagine.

    A logical conclusion based...

  • RE: Are the posted questions getting worse?

    Anyone here planning to (or thinking about) going to Live! 360 Orlando?

    As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the...

  • RE: A Case FOR Cursors...

    David.Poole (9/15/2016)


    Doesn't a while loop tend towards the nature of a dynamic cursor rather than a static cursor?

    Depends on how you build it. If you repeat the query in each...

Viewing 15 posts - 331 through 345 (of 3,348 total)