Forum Replies Created

Viewing 15 posts - 25,081 through 25,095 (of 59,099 total)

  • RE: Double quotes on Bulk Insert

    Luis Cazares (12/20/2013)

    Hi all,

    I'm migrating some DTS packages into SP. I managed to load the information using BULK INSERT and [font="Arial Black"]format files [/font]to remove double quotes(") that identify character...

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

    December 20, 2013 at 5:53 pm

    #1675355

  • RE: MCSE or BI

    _nzrdb6 (12/20/2013)

    WHat would be more useful for a production DBA to pick up - MCSE type material or SQL Server BI stuff?

    Neither, IMHO. Some really hard-core, "Black Arts" T-SQL...

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

    December 20, 2013 at 5:36 pm

    #1675354

  • RE: Database need to be replicated

    If both servers share a SAN, some SANs have what I call a "SAN Snapshot" that will very nearly instantaneously create a copy of an existing database on the "other"...

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

    December 20, 2013 at 5:19 pm

    #1675348

  • RE: SYNTAX Help please...

    dwain.c (12/18/2013)

    Jeff Moden (12/18/2013)

    Using no more arcane knowledge than knowing that NULL can't be "not equal" to anything, the following code will do the same thing even on fixed length...

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

    December 20, 2013 at 5:10 pm

    #1675346

  • RE: SYNTAX Help please...

    Evil Kraig F (12/19/2013)

    IT2012 (12/19/2013)

    As is the case with all "canned" software, seems we always need functionality that doesn't quite come with the package. SO.... I'm teaching myself...

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

    December 20, 2013 at 5:07 pm

    #1675345

  • RE: SYNTAX Help please...

    Evil Kraig F (12/20/2013)

    Jeff, neat trick with the a.Field > ''. Was unaware of that.

    Thanks for the feedback, Craig. And, because comparatively few people are aware of that,...

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

    December 20, 2013 at 5:04 pm

    #1675343

  • RE: SYNTAX Help please...

    ScottPletcher (12/20/2013)

    There could be great harm in it if either (1) SQL could have done seeks on both terms and produced the final output more efficiently than for only one...

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

    December 20, 2013 at 3:39 pm

    #1675326

  • RE: SYNTAX Help please...

    IT2012 (12/19/2013)

    WOW!!!!!! Reading through these posts makes me wonder whether I DARE post any more "please help" questions considering my lack of expertise. I assure you my intent...

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

    December 20, 2013 at 2:54 pm

    #1675319

  • RE: SYNTAX Help please...

    ScottPletcher (12/20/2013)

    Jeff Moden (12/20/2013)

    ScottPletcher (12/19/2013)

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not 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)

    December 20, 2013 at 2:34 pm

    #1675316

  • RE: SYNTAX Help please...

    IT2012 (12/19/2013)

    WOW!!!!!! Reading through these posts makes me wonder whether I DARE post any more "please help" questions considering my lack of expertise. I assure you my intent...

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

    December 20, 2013 at 12:57 pm

    #1675296

  • RE: SYNTAX Help please...

    ScottPletcher (12/19/2013)

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use it 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)

    December 20, 2013 at 11:47 am

    #1675274

  • RE: SQL Query help to Split AD data

    Lowell (12/18/2013)

    it might be easier to just query the active directory from SQL via a linked server.

    then the pieces can be pulled out automatically;

    does this help you at all? 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)

    December 18, 2013 at 9:24 pm

    #1674699

  • RE: SYNTAX Help please...

    ScottPletcher (12/18/2013)

    I'm truly curious now:

    Can anyone tell me:

    Where "IS NULL" can't be used in place of ISNULL()?

    Without the help of a CASE statement, lot's of places. Here's a...

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

    December 18, 2013 at 9:10 pm

    #1674698

  • RE: SYNTAX Help please...

    Evil Kraig F (12/18/2013)

    ScottPletcher (12/18/2013)

    Yikes! Table values should be trimmed by a trigger once during insert/update if necessary rather than in every query afterward. If you really need...

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

    December 18, 2013 at 8:47 pm

    #1674697

  • RE: SYNTAX Help please...

    ScottPletcher (12/18/2013)

    At any rate, the ANSI-standard COALESCE() could always be used in place of ISNULL().

    Why? Do you believe in the myth of "portability"?

    COALESCE also has a hidden problem that ISNULL...

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

    December 18, 2013 at 8:39 pm

    #1674696

Viewing 15 posts - 25,081 through 25,095 (of 59,099 total)