Forum Replies Created

Viewing 15 posts - 38,791 through 38,805 (of 59,098 total)

  • RE: When not to use a temporary table?

    In fact, the LIKE's are a "hack" for doing a lookup on space delimited data. If you want this to fly, that space delimited data should probably be normalized....

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

    April 22, 2010 at 1:57 pm

    #1156411

  • RE: When not to use a temporary table?

    The LIKEs will also kill performance because they have a wwildcard on each side. It's not the temp table that's your problem.

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

    April 22, 2010 at 1:51 pm

    #1156407

  • RE: No One is Safe

    Michael Valentine Jones (4/22/2010)

    Steve Jones - Editor (4/22/2010)

    Or hope we have good backups! :w00t::hehe:

    Please don't try that Michael. I suspect there are holes in what my devs built

    I won't, 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)

    April 22, 2010 at 1:26 pm

    #1156397

  • RE: Centrally located stored procs?

    John Rowan (4/22/2010)

    I'm with Steve here. This is a change management issue. I would develop a process to deliver the SP changes to your client DBs.

    I definitely agree...

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

    April 22, 2010 at 1:06 pm

    #1156386

  • RE: Centrally located stored procs?

    Lowell (4/20/2010)

    bagofbirds-767347 (4/20/2010)

    thanks. i do indeed use central functions for things like string/date operations. But my problem is getting the procs to work with data in the correct...

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

    April 22, 2010 at 12:07 pm

    #1156352

  • RE: MCJ - The Missing Link

    Jason,

    I thought you had it but I just sent you my email address, just 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)

    April 22, 2010 at 10:23 am

    #1156286

  • RE: Substring Function in Where Clause

    eseosaoregie (4/22/2010)

    There are rows which do not contain the 3 letter character representation of a week day at characters 2 through 4. They are:

    '[Spreadsheet Extractor Big Block Allocs --...

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

    April 22, 2010 at 9:48 am

    #1156243

  • RE: Substring Function in Where Clause

    Ah... almost forgot... I also need to know how many rows are in the staging table that you've been testing with and how long the split runs have been.

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

    April 22, 2010 at 6:42 am

    #1156042

  • RE: Substring Function in Where Clause

    bc_ (4/21/2010)

    try:

    comp_column IN ('mon ','tue ','wed ','thu ','fri ','sat ','sun ')

    Why? comp_column only contains 3 characters according to the OP's posted code.

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

    April 22, 2010 at 6:40 am

    #1156038

  • RE: Substring Function in Where Clause

    eseosaoregie (4/21/2010)

    I have now added sample data along with all the code for tables and indexes etc. Hopefully this will make things clearer

    ---tables

    CREATE TABLE [stg_LogFiles] (

    ...

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

    April 22, 2010 at 6:30 am

    #1156026

  • RE: A DBA's Daily routine (and other items...)

    Heh... move your chair into his cube and tell him you'll leave when he's taught you to know as much as him. Be sure to let your deoderant fail....

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

    April 21, 2010 at 4:35 pm

    #1155759

  • RE: SQL Syntax

    kabaari (4/21/2010)

    Coldcoffee,

    Thanks. Not sure if posting data would apply in this situation. But, I posted data in the past and ended up with people responding with how valuable their time...

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

    April 21, 2010 at 4:30 pm

    #1155756

  • RE: Substring Function in Where Clause

    eseosaoregie (4/21/2010)

    my tables are:

    ---index

    CREATE

    INDEX [IX_FirstFour] ON stg_LogFiles ([Firstfour])

    WITH

    DROP_EXISTING

    ON [PRIMARY]

    ---tables

    CREATE TABLE [stg_LogFiles] (

    [LineRead] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

    [Importeddate] [datetime] NULL CONSTRAINT [DF__stg_LogFi__Impor__5441852A] DEFAULT...

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

    April 21, 2010 at 4:26 pm

    #1155752

  • RE: Alter table on-the-fly

    Trybbe (4/21/2010)

    Hi thanks for the feedback, I totaly agree with you but the problem is that changes to the tables are done by a different team from a production side...

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

    April 21, 2010 at 4:20 pm

    #1155748

  • RE: Import only good rows

    My recommendation is to never import directly from any source even if you're the one that built the source... it's an invitation for disaster. Import the data into 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)

    April 21, 2010 at 4:17 pm

    #1155746

Viewing 15 posts - 38,791 through 38,805 (of 59,098 total)