Forum Replies Created

Viewing 15 posts - 54,901 through 54,915 (of 59,072 total)

  • RE: Oh, HELL NO!

    Mr. Cranky Poopy Pants?  Well, that "depends"... 😛

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

    September 24, 2007 at 7:36 am

    #735604

  • RE: Oh, HELL NO!

    Heh... If you couldn't tell, I was ticked about this particular problem a wee bit more than the others 😀  Ol' dogs CAN learn new tricks... we're just tired of...

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

    September 24, 2007 at 7:18 am

    #735597

  • RE: txt file importing

    Muhammad Furqan (22/09/2007)

    ok, some sample data

    randomdata;10/10/2007;randomdata;randomdata;

    Column1;Column3;Column5;Column4;Column2;

    jk adkshfjhjkfhsajkfh sda;sdfs dfasdfsda;fsdaf sadfadsfsda;

    dsf;sdf;sdf;sdfds;sdfsd;

    So, here is the description.

    First line, i dont want it to be in the table, but contains date that i want...

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

    September 23, 2007 at 10:28 am

    #735490

  • RE: High sal from table

    Sounds a whole lot like interview or homework questions... would have loved to see the reply... "What have YOU tried?" 😀

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

    September 23, 2007 at 10:16 am

    #735489

  • RE: How BCP Utility can help performance

    ...And, BULK INSERT, even with the use of a format file, even beats BCP.  That's because BULK INSERT is a wee bit less functional than BCP... for example, BULK INSERT...

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

    September 23, 2007 at 10:09 am

    #735488

  • RE: how do you secure SQL against everyone?

    Now... THAT I agree with! 😀

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

    September 23, 2007 at 9:38 am

    #735486

  • RE: how do you secure SQL against everyone?

    If you're using windows authentication, then have the domain admins create a windows group for the developers and grant that access to SQL.

    Yeah... just not for access to the Production...

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

    September 23, 2007 at 8:59 am

    #735484

  • RE: find data type of a field in a select

    Ya know... I actually get this one... there's been a couple of times that I've had to lookup the datatype for SysName and @@ServerName and the like just because 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)

    September 23, 2007 at 8:51 am

    #735483

  • RE: Linked Server Performance

    No... sorry, I can't.  I've never had to connect SQL Server to an AS 400... 

    Lookup "DTS Driver Support for Heterogeneous Data Types" in Books Online... I believe these would be...

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

    September 23, 2007 at 8:41 am

    #735481

  • RE: What Do You Think of the New Site

    There's a lot of things I don't like about the new site, to wit, reasons why I don't use other sites.

    I've pretty much beat up on the "Recent Posts" 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)

    September 23, 2007 at 8:33 am

    #735480

  • RE: ReadMe

    1. Ok... I just lost my post by hitting the Preview button... would you please fix that first 😀
    2. Also, lot's of functionality has been lost under the "Recent Posts" link... 

    1. What...

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

    September 22, 2007 at 4:27 pm

    #735451

  • RE: Adding Features Back

    1. Ok... I just lost my post by hitting the Preview button... would you please fix that first 😀
    2. Also, lot's of functionality has been lost under the "Recent Posts" link... 

    1. What...

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

    September 22, 2007 at 4:23 pm

    #735450

  • RE: Populate a table with a directory's file info.

    Great idea... but do you write production code the same way?  :blink:  No documentation, no formatting to speak of, no header?

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

    September 22, 2007 at 9:34 am

    #735440

  • RE: Pivot Cross Tab for Text Results

    I frequently DO tell the vendor 😛  Many times, I'll find an alternate that does the job right and start migrating business from the uncooperative vendor.  For sole source vendors, I teach...

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

    September 22, 2007 at 9:08 am

    #735438

  • RE: Whitepaper for developers

    Maybe... but how ya gonna know about SOX violations if no one reviews the code? 😛

    Bottom line is to protect the data and the server.  Slow running code has the...

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

    September 22, 2007 at 9:01 am

    #735435

Viewing 15 posts - 54,901 through 54,915 (of 59,072 total)