Forum Replies Created

Viewing 15 posts - 18,001 through 18,015 (of 26,484 total)

  • RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

    Jeff Moden (12/10/2009)


    clive-421796 (12/10/2009)


    Cant open a .rar (winrar) file ? Ah come on Jeff, never heard of anyone working in IT for years that does not have winrar...

  • RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

    clive-421796 (12/10/2009)


    Cant open a .rar (winrar) file ? Ah come on Jeff, never heard of anyone working in IT for years that does not have winrar installed. Go...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/10/2009)


    Lynn Pettis (12/10/2009)


    GSquared (12/10/2009)


    Lynn Pettis (12/10/2009)


    Roy Ernest (12/10/2009)

    I dont fall under that category..I know nothing.... I know nothing... :w00t:

    Dating myself here, but I actually hear Sgt Shultz from...

  • RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

    Just an fyi, when doing date range comparisions, especially when the datetime column you are using also stores time values other than 00:00:00.000, the best method is like this:

    ...

    WHERE

    ...

  • RE: Are the posted questions getting worse?

    GSquared (12/10/2009)


    Lynn Pettis (12/10/2009)


    Roy Ernest (12/10/2009)

    I dont fall under that category..I know nothing.... I know nothing... :w00t:

    Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:

    When you...

  • RE: Join problem in query

    Grasshopper (aka sk.panda ),

    Would like a correct answer or just shots in the dark?

    If you want a correct answer, please read and follow the instructions in this article[/url] and post...

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/10/2009)


    I'm 31 and I know Schultz, so you're not dating yourself that badly.

    Now if you actually knew him during the war, that would be dating yourself...:-P

    Okay, I saw...

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/10/2009)

    I dont fall under that category..I know nothing.... I know nothing... :w00t:

    Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:

  • RE: Lock Pages in Memory

    Bru Medishetty (12/10/2009)


    GSquared (12/10/2009)


    Or fire up Windows Task Manager and take a look at what's running. But that might be too easy and too direct.

    Gus, how to fire Windows...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/10/2009)


    GSquared (12/10/2009)


    Roy Ernest (12/10/2009)


    To be honest, There are lots of Indians here who give other Indians a bad name... 🙁

    And plenty of Americans who give us a bad...

  • RE: Subquery evaluation

    It is my understanding, and I may be wrong, that SQL Server does not do short-curcuiting when evaluating the WHERE clause. If I am wrong, I'd welcome being corrected...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (12/10/2009)


    Back to the lock pages thread

    GilaMonster (12/10/2009)


    Krasavita (12/10/2009)


    I already have AWE check and I have Standard Edition.

    If you have Standard edition of SQL 2000 then this entire conversation has...

  • RE: Lock Pages in Memory

    Krasavita (12/10/2009)


    ...

    Are there other apps on the server that SQL has to share the box with.

    How Can I check other apps on the server that SQL has to share...

  • RE: Are the posted questions getting worse?

    David Burrows (12/10/2009)


    Lynn Pettis (12/10/2009)


    I was stationed in England for 2.5 years. You know how we knew we were having a heat wave? The old people started dying...

  • RE: Are the posted questions getting worse?

    I was stationed in England for 2.5 years. You know how we knew we were having a heat wave? The old people started dying of heat stroke. ...

Viewing 15 posts - 18,001 through 18,015 (of 26,484 total)