Forum Replies Created

Viewing 15 posts - 32,371 through 32,385 (of 59,102 total)

  • RE: SQL-Server 2005: Change Ordinal Column Position

    Sean Lange (10/7/2011)


    Man it is hard to believe there still 3rd party things that are that short sighted. Sad actually.

    It's not a fault... it's a feature! 😀 Keeps people...

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

  • RE: Query to combine two fields into one output

    I don't believe that anyone has written about the performance penalty of using VARCHAR(MAX) and I haven't made a specific test for it. My statement comes from when 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)

  • RE: Best approach to import text file?

    WaitingWonder2 (10/3/2011)


    Here is the table:

    IF OBJECT_ID('tBufOMIM') IS NULL

    BEGIN

    CREATE TABLE tBufOMIM (

    NOINT NOT NULL PRIMARY KEY,

    TIVARCHAR(MAX)NULL,

    TXVARCHAR(MAX)NULL,

    SAVARCHAR(MAX)NULL,

    CSVARCHAR(MAX)NULL,

    CNVARCHAR(MAX)NULL,

    RFVARCHAR(MAX)NULL,

    CDVARCHAR(MAX)NULL,

    EDVARCHAR(MAX)NULL,

    MNVARCHAR(MAX)NULL,

    AVVARCHAR(MAX)NULL

    )

    PRINT 'Table tBufOMIM was created'

    END

    GO

    Format file:

    <BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <RECORD>

    <FIELD ID="1" xsi:type="CharTerm" TERMINATOR="*RECORD**FIELD* NO"/>

    ...

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

  • RE: Best approach to import text file?

    codebyo (10/3/2011)


    Jeff Moden (10/3/2011)

    The BCP format file would use similar delimiters and row terminators as you have in your BULK INSERT example (which is very nicely done, BTW). Perhaps...

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

  • RE: Where are all the MVBs?

    IIRC, SQLServerCentral.com tried a Wiki when they switched forum software many years back. Basically, it was an "unmanaged" Wiki where anyone could make additions/changes/deletions.

    My opinion about public "unmanaged" Wiki's...

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

  • RE: SQL-Server 2005: Change Ordinal Column Position

    paul.t.silvey (10/6/2011)


    Yes, COLUMN ORDER DOES MATTER in some data layer tier applications. They look to the first column being the primary key and if an ID column was added at...

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

  • RE: Rookie DBA

    codebyo (10/7/2011)


    Jeff Moden (10/6/2011)


    Ah... yeah... found it...

    http://www.brentozar.com/sql/becoming-a-dba/

    That's brilliant! Thank you.

    Bookmarked. 🙂

    Best regards,

    You bet. Brent did a wonderful job and did a lot of work putting all of that together....

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

  • RE: Rookie DBA

    Ah... yeah... found it...

    http://www.brentozar.com/sql/becoming-a-dba/

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

  • RE: Rookie DBA

    codebyo (10/6/2011)


    Jeff Moden (10/6/2011)Done correctly, the study programs for certs are an incredible path to knowledge... but certs aren't the only path available.

    Indeed. You're absolutely right.

    There's something I'd like to...

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

  • RE: Rookie DBA

    JamesMorrison (10/6/2011)


    The ones with experince and no certifications typically are the types who get silo'd and limited to just the basics.

    This leads to a lack in broad understanding of areas...

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

  • RE: Are the posted questions getting worse?

    SQL Kiwi (10/5/2011)


    Evil Kraig F (10/5/2011)


    Second Interview? Isn't that the time when they go "Sign here for benefits and salary agreements?" Didn't know that was an interview....

    No idea....

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

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/5/2011)


    Oh Jeff, look what your "simple" question has done!

    I know... pretty devious, huh? 😛 The good ones just can't stand such a simple question. They'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)

  • RE: Are the posted questions getting worse?

    Chad Crawford (10/5/2011)


    Stefan Krzywicki (10/5/2011)


    Jeff Moden (10/5/2011)


    Ninja's_RGR'us (10/5/2011)


    Jeff Moden (10/4/2011)


    GilaMonster (10/4/2011)


    Jeff Moden (10/4/2011)


    I wonder how many of us there are that try to completely ignore certs and degrees in...

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

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (10/5/2011)


    Jeff Moden (10/4/2011)


    GilaMonster (10/4/2011)


    Jeff Moden (10/4/2011)


    I wonder how many of us there are that try to completely ignore certs and degrees in the interview process?

    I don't. If the person...

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

  • RE: HierarchyID performance problems... Really???

    ALZDBA (10/5/2011)


    BTW you don't need million row objects to get into performance problems, so strive for most optimal setup as much as you can !

    Heh... true enough. Some 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)

Viewing 15 posts - 32,371 through 32,385 (of 59,102 total)