Forum Replies Created

Viewing 15 posts - 45,796 through 45,810 (of 59,095 total)

  • RE: Are the posted questions getting worse?

    Heh... Someone (another MVP, actually) recently suggested that I write an article having to do with optimizing cursors for those who can't or won't think in terms of set based...

    --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 18, 2009 at 9:53 pm

    #929015

  • RE: Cursor

    rog pike (1/17/2009)

    Jeff Moden (1/17/2009)

    Simon,

    I wonder if you'd do me a favor... I realize it's been about 4 months since the last post, but I need to ask... why did...

    --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 18, 2009 at 9:25 pm

    #929009

  • RE: Phone Numbers Table Design

    Krishna_DBA (1/17/2009)

    CREATE TABLE ContactPhone

    (

    --Numbers for NANPA--

    CountryCode_NPAnvarchar(10),--Country code for NANPA DEFAULT '1'

    AreaCode_NPA nvarchar(10),--Area code for NANPA

    Exchange_NXX nvarchar(10),--Exchange...

    --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 18, 2009 at 9:22 pm

    #929008

  • RE: Phone Numbers Table Design

    Krishna_DBA (1/17/2009)

    So, I have to create separate table for NANPA phone numbers alone and their codes?

    No, no... look at what I wrote in my last post. 1 Table...

    --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 17, 2009 at 8:43 pm

    #928817

  • RE: Hidden RBAR: Triangular Joins

    You give up too easy.

    --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 17, 2009 at 8:41 pm

    #928816

  • RE: Surface Possibilities

    First, they've had such screens, admittedly with a bit less sophistication, as bar cash registers for years. It's just a different application of some old technology.

    The other thing 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 17, 2009 at 8:03 pm

    #928813

  • RE: Select Where_Min()

    RBarryYoung (1/17/2009)

    Jeff Moden (1/17/2009)

    Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen...

    --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 17, 2009 at 7:54 pm

    #928812

  • RE: Phone Numbers Table Design

    Jeff Moden (1/17/2009)

    Heh... science it out... how many parts of a phone number for a NANPA phone number and how many parts for an International Number?

    After that, ask yourself... "If...

    --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 17, 2009 at 7:51 pm

    #928811

  • RE: Phone Numbers Table Design

    Heh... science it out... how many parts of a phone number for a NANPA phone number and how many parts for an International 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 17, 2009 at 7:42 pm

    #928810

  • RE: Need output as 1,2,3,...10

    arup_kc (1/15/2009)

    Hi Gail,

    This is actualy a question, which I have faced in an interview. I have tried with ROW_Number function later but no result.

    That's why I have posted 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 17, 2009 at 7:31 pm

    #928809

  • RE: how many db's on one server

    I agree with Gus... it doesn't matter how many databases you have on a given instance of SQL Server... it's resource usage that matters. How many users are logged...

    --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 17, 2009 at 7:25 pm

    #928807

  • RE: SQL Bulk Insert

    Yes... Select/Into will do minimal logging under the right conditions. But, it also builds the table... you would have to drop the target table first.

    --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 17, 2009 at 7:22 pm

    #928806

  • RE: Cursor

    Simon,

    I wonder if you'd do me a favor... I realize it's been about 4 months since the last post, but I need to ask... why did you need to do...

    --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 17, 2009 at 7:00 pm

    #928803

  • RE: Evaluate a string Expression

    rog pike (1/17/2009)

    Jeff Moden (1/16/2009)

    Heh... Come on folks. "We don need no stinkin' CLR!" 😛 This is a simple problem and it doesn't need a CLR. ...

    --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 17, 2009 at 6:29 pm

    #928799

  • RE: Select Where_Min()

    Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen where a Loop...

    --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 17, 2009 at 6:19 pm

    #928798

Viewing 15 posts - 45,796 through 45,810 (of 59,095 total)