Forum Replies Created

Viewing 15 posts - 49,456 through 49,470 (of 59,102 total)

  • RE: Bulk Insert and Index Considerations

    BCP uses the log only if you've not met the requirements for "minimal logging". Otherwise, it will minimally log... just like BULK INSERT which is actually faster than BCP.

    Please...

    --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)

    July 4, 2008 at 10:30 am

    #838399

  • RE: Handling hirarchy in tables

    Ok... now, I'm impressed! I've not reviewed all of the code in the good article recommended by Rashmi, yet... but the author (James Simpson) has done a strange 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)

    July 4, 2008 at 10:13 am

    #838396

  • RE: Handling hirarchy in tables

    rashmi.todkar (7/4/2008)

    by the way this is also a very good link for nested sets

    http://www.codeproject.com/KB/database/nestedsets.aspx

    That is a good article... graphics for the explanations are spot on and done well.

    Heh......

    --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)

    July 4, 2008 at 10:03 am

    #838393

  • RE: Handling hirarchy in tables

    rashmi.todkar (7/4/2008)

    Thanks all.

    I gone through nested sets options its really best one for high performance reads on such data. but update and insert is bit costly however I can afford...

    --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)

    July 4, 2008 at 9:54 am

    #838391

  • RE: CLR Assemblies

    Greatings Mr. Burrows! Say... are you going to make the trek to Pass this fall? If you are, look for the guy wearing my avatar on the back...

    --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)

    July 4, 2008 at 9:50 am

    #838390

  • RE: Output to csv

    Shodman (7/2/2008)

    Hi Folks

    I am trying to do a simple query and output to a csv file.

    SELECT *

    FROM mytable

    OUTPUT TO c:\mycsvfile.csv

    Could somebody please advise why this isn't working.

    I've read through loads...

    --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)

    July 4, 2008 at 12:27 am

    #838225

  • RE: eliminating duplicates

    Just so you know... I've had it take as long a 6 weeks from the submital date to have an article published and as little as 1 week. 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)

    July 4, 2008 at 12:14 am

    #838221

  • RE: Table of Numbers (Tally Table)

    Apparently, my Windows Live account signup hasn't made it this far, yet. Needless to say, I have some pretty strong feelings in the area of Tally tables... 😉

    ... I'll...

    --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)

    July 3, 2008 at 11:35 pm

    #838210

  • RE: Dynamic USE clause

    Sidebar: Yeah, I agree... this is one of the few and only places where I suppose it's ok to use a cursor... you just won't see me doing 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)

    July 3, 2008 at 11:01 pm

    #838208

  • RE: Dynamic USE clause

    David Kranes (7/3/2008)

    Yes you are correct. But this works fine.

    DECLARE

    @DBName VARCHAR(100),

    @sql NVARCHAR(4000),

    SELECT @sql = N'use...

    --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)

    July 3, 2008 at 10:57 pm

    #838207

  • RE: Parse Text Variable in UDF

    Heh... It's the helmet, Barry... ya gotta remember to plug in the O2 😛 Can't do it all on just coffee, ya know? :w00t:

    --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)

    July 3, 2008 at 10:34 pm

    #838205

  • RE: Displaying the fields only once

    New Commer (7/3/2008)

    Hi There!

    i have a query like this,

    Select Distinct Table1.name, Table1.Code, Table2.Place, Table2.Marks From Table1 inner join Table2 on Table1.code = Table2.code

    which results,

    Name1/N1/Nagpur/114

    Name1/N1/Nagpur/154

    Name1/N1/Nagpur/123

    i want it to display as

    Name1/N1/Nagpur/114

    ...

    --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)

    July 3, 2008 at 10:29 pm

    #838204

  • RE: Displaying the fields only once

    Vijaya Kadiyala (7/3/2008)

    hi,

    You can't implement this logic in DB side

    I agree that formatting for display should, indeed, be done in the GUI.... BUT, gosh, you really need to be sure...

    --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)

    July 3, 2008 at 10:25 pm

    #838203

  • RE: A discrepancy in the amounts being totaled

    Heh... yeaup... we've all been there.

    My problem is that I end up double and triple checking my query, find out that it's spot on, and that someone really did screw...

    --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)

    July 3, 2008 at 9:59 pm

    #838202

  • RE: Are Stored Procedures Evil?

    Tim OPry (4/17/2008)

    I did think he made several interesting points and would be interested in what some of you think:

    My personal feeling is that Tony just doesn't like writing stored...

    --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)

    July 3, 2008 at 9:53 pm

    #838199

Viewing 15 posts - 49,456 through 49,470 (of 59,102 total)