Forum Replies Created

Viewing 15 posts - 46,201 through 46,215 (of 59,095 total)

  • RE: Cursors Be Gone!

    Matt Whitfield (1/2/2009)

    Hmmm. Just wrote a massive reply and the session timed out!!

    Oh well. The long and short of it was:

    1) It's pretty trendy to bash microsoft, but I'm going...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 2, 2009 at 9:42 am

    #920371

  • RE: Cursors Be Gone!

    Lawrence (1/1/2009)

    Jeff, I've been following this post as I am a SQL Noob and walked into a position where cursors are everywhere and I'm trying to understand when/when not to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 2, 2009 at 9:29 am

    #920359

  • RE: Cursors Be Gone!

    Tom.Thomson (1/2/2009)

    I think you are being a bit unfair to him,Jeff.

    Heh... Yet, you just agreed with everything I said about UPDATE. 😉 The real fact of the matter is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 2, 2009 at 9:19 am

    #920349

  • RE: Cursors Be Gone!

    jacroberts (1/2/2009)

    Jeff Moden (1/1/2009)

    One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.

    When you say "fellow MPV's"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 2, 2009 at 9:12 am

    #920338

  • RE: Cursors Be Gone!

    Alexander Kuznetsov (12/24/2008)

    Actually in most cases the best alternative is a loop written in a modern language such as C#, not a T-SQL WHILE loop or a CURSOR. Not only...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 2, 2009 at 9:05 am

    #920336

  • RE: Cursors Be Gone!

    repicurus (12/24/2008)

    I would be happy to contribute TWO examples that I do not think could be accomplished WITHOUT cursors.

    There are several places where I agree that at least a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 2, 2009 at 9:00 am

    #920327

  • RE: Ok, its their first day on the job.

    BWAAA-HAAA!!! The next problem is... finding a good book! 😉 Many of the folks that write such books have some pretty severe ego problems themselves. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 7:41 pm

    #920071

  • RE: getting all records between 2 fridays of a given date

    Piotr Rodak (1/1/2009)

    Now, that's a cunning trick I see now Jeff :w00t:

    Not earlier than yesterday I said to myself 'one day I have to get those dateadd-datediff calculations sorted out'.

    And...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 7:37 pm

    #920069

  • RE: Partitining an existing table

    I'm not sure what you're talking about. A clustered index IS the data and adds almost nothing to the size of the table.

    My feeling is that you've not done...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 7:33 pm

    #920068

  • RE: Split a date-range into periods

    HanShi (10/23/2008)

    I have work out your solution. Maybe others can benefit from this code.

    As you allready mentioned, this solution is more generic. The TALLY table now only contains the number...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 7:10 pm

    #920062

  • RE: help with sqlcmd

    Lookup "OSQL Utility" in Books Online.

    The real key here is, why are you trying to do this from the command line... SQL Server can check to see if a file...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 6:55 pm

    #920059

  • RE: Partitining an existing table

    I read the article, probably I dont have a high IQ, could you please let me know what I've done wrong and what I should do?

    Reading just one article probably...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 6:19 pm

    #920054

  • RE: getting all records between 2 fridays of a given date

    Piotr Rodak (1/1/2009)

    It does unfortunately..

    set language us_english

    go

    select @@datefirst, datepart(dw, getdate())

    go

    set language british

    go

    select @@datefirst, datepart(dw, getdate())

    I had to cope with this on a few occasions.

    Piotr

    That would be true if I used...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 5:59 pm

    #920053

  • RE: Cursors Be Gone!

    One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 5:52 pm

    #920052

  • RE: getting all records between 2 fridays of a given date

    Datefirst doesn't even come into play on this...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 1, 2009 at 2:26 pm

    #920033

Viewing 15 posts - 46,201 through 46,215 (of 59,095 total)