Forum Replies Created

Viewing 15 posts - 45,631 through 45,645 (of 59,101 total)

  • RE: Slack SQL Server

    Joshua Perry (1/23/2009)

    Create a new class library with your favorite .NET language:

    Man, I appreciate your effort, but, heh... the no such thing for me. 😉

    --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 23, 2009 at 5:47 pm

    #932109

  • RE: Slack SQL Server

    Matt Miller (1/23/2009)

    Jeff Moden (1/23/2009)

    I'll add another wish... there's a lot of things (not just running totals) that require "looking" at a range of previous or next rows. It...

    --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 23, 2009 at 5:41 pm

    #932106

  • RE: Slack SQL Server

    Matt Miller (1/23/2009)

    As for me, I would settle for actual, complete, documentation of the new features added as they are added. Functionality changes, "this doesn't work in x version...

    --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 23, 2009 at 5:39 pm

    #932105

  • RE: Slack SQL Server

    JJ B (1/23/2009)

    Jeff Moden (1/23/2009)

    I'm good with that... I've used both Oracle and SQL Server... I have to admit that I "cut my teeth" on SQL Server so there's some...

    --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 23, 2009 at 2:27 pm

    #932061

  • RE: The T-SQL Quiz

    Heh... Ok... Game on! 😉

    --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 23, 2009 at 10:17 am

    #931939

  • RE: Slack SQL Server

    JJ B (1/23/2009)

    I appreciate all the ideas posted here. They have re-awakened some of my own itches.

    At the same time, looking at these posts has depressed me. I...

    --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 23, 2009 at 10:06 am

    #931932

  • RE: Disable and enable trigger

    anbillava (1/23/2009)

    I am able to do it by some of other posts in the portal. Thanks for all your info. I am actually working mas data archive and restore stuff....

    --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 23, 2009 at 10:01 am

    #931929

  • RE: Why do people need to do this?

    Goldie Graber (1/23/2009)

    O jeez... failing memory... is it "Gloria"?

    Nope, it's Goldie. 🙂 I think I'm going to change my user name.

    And, thanks... that's one of the posts I...

    --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 23, 2009 at 9:58 am

    #931926

  • RE: Why do people need to do this?

    ggraber (1/23/2009)

    Don't know if this helps, Jeff, but I found a post from a few months back that was asking to solve this problem.

    The OP did not say why he...

    --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 23, 2009 at 9:47 am

    #931907

  • RE: Wierd Counter!

    JohnDBA (10/23/2008)

    Please help me!

    I have this values that I need to count based on condition.

    - If the value is between 10 and 15 and the code is = 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 23, 2009 at 9:46 am

    #931906

  • RE: Why do people need to do this?

    Garadin (1/23/2009)

    WTF-itude.

    Heh... aswesome... new word for my IT dictionary... should be included in the definition of RBAR as a result of a set based programmer finding RBAR in code. ...

    --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 23, 2009 at 9:41 am

    #931900

  • RE: Slack SQL Server

    I'll add another wish... there's a lot of things (not just running totals) that require "looking" at a range of previous or next rows. It would be handy 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 23, 2009 at 9:36 am

    #931896

  • RE: Slack SQL Server

    MelS (1/23/2009)

    Add a lightning-fast way to encrypt and decrypt data. Even following Microsoft's suggestions to combine symmetric and asymmetric functions, performance isn't there. And what about indexing on...

    --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 23, 2009 at 9:34 am

    #931891

  • RE: Slack SQL Server

    sing4you (1/23/2009)

    My big beef is with the date functions. I often have to calculate how many years, months and days between two dates. SQL will tell you that...

    --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 23, 2009 at 9:32 am

    #931889

  • RE: Slack SQL Server

    majorbloodnock (1/23/2009)

    michael vessey (1/23/2009)

    bank holidays and non working days functions

    Agreed. Has anyone else looked at the calculation necessary to work out Easter? I had to write one a few years...

    --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 23, 2009 at 9:30 am

    #931887

Viewing 15 posts - 45,631 through 45,645 (of 59,101 total)