Forum Replies Created

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

  • RE: Hidden RBAR: Triangular Joins

    Charles Kincaid (1/19/2009)

    Sorry, Jeff. I was not clear enough. My contention is that a C# CLR proc and a VB CLR proc would run the same as each...

    --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 19, 2009 at 1:14 pm

    #929358

  • RE: Surface Possibilities

    Steve Jones - Editor (1/18/2009)

    I hadn't thought about the repetitive motion thing. I guess long term it could be, but for presentations, they're an hour or two. I wish 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 19, 2009 at 11:23 am

    #929330

  • RE: Why do people need to do this?

    Ramesh (1/18/2009)

    I would like to share my thoughts on the need of such rules.

    I have the punch/swipe card data imported from some other system in the following format...

    EmployeeNo, CardReaderNo, CardReaderType,...

    --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 19, 2009 at 10:57 am

    #929323

  • RE: Hidden RBAR: Triangular Joins

    Charles Kincaid (1/19/2009)

    Given competent coders on both sides C# vs VB races based on execution speeds mostly end in dead heats.

    Hi Charles... thanks for joining in. Just curious about...

    --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 19, 2009 at 10:50 am

    #929321

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

    ... and, still, in an interview, none of the solutions are the correct answer.

    Other than a firedrill on this forum, when have any of you actually had to concatenate data...

    --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 10:11 pm

    #929018

  • RE: Selecting from temp table outside SP?

    ALZDBA (1/18/2009)

    1) create your temp tables up front in stead of using select into.

    What is the advantage?

    --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 10:05 pm

    #929017

  • 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

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