Forum Replies Created

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

  • 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

  • RE: Are Stored Procedures Evil?

    Peter Schofield (7/3/2008)

    Stored procedures in SQL Server are the primary way to go for data access & manipulation for performance, security, and modularity.

    That's a great thing to say... but, even...

    --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:40 pm

    #838197

  • RE: Parse Text Variable in UDF

    rbarryyoung (7/3/2008)

    Here is a post that has as good example of a Split function that works very well. It use varchar(MAX) but you can change them to NVarchar(MAX).

    As for...

    --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:34 pm

    #838196

  • RE: Non sargable mightmare

    Matt Miller (7/3/2008)

    but still - technically possible....

    Maybe THAT'S where you should use a cursor! 😀

    --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:18 pm

    #838193

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