Forum Replies Created

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

  • RE: TD Alignment in Database Mail

    freewaresucks (12/20/2013)

    This is a really old post i dont expect nothing just mind blowing to me. How in the bleep did you figure that out....... Anyway thanks guys for 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 9:34 pm

    #1675363

  • RE: SYNTAX Help please...

    ScottPletcher (12/20/2013)

    Evil Kraig F (12/20/2013)

    ScottPletcher (12/20/2013)

    Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original...

    --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 8:14 pm

    #1675358

  • RE: Sound Matching and a Phonetic Toolkit

    AVB (12/20/2013)

    I had the same problem of getting the dll to work with 2008. I'm in the process of converting a 2000 db to 2008 and I used that xp_NYSIIS...

    --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 6:42 pm

    #1675356

  • 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

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