Forum Replies Created

Viewing 15 posts - 17,866 through 17,880 (of 59,069 total)

  • RE: Creating an Index Strategy

    TheSQLGuru (4/14/2016)

    Jeff, the next time you and I are together FTF (SQL Saturday or PASS Summit?) we need to have a long, detailed talk about the things you state below....

    --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 14, 2016 at 9:30 am

    #1872034

  • RE: Today's Random Word!

    djj (4/13/2016)

    crookj (4/13/2016)

    Hugo Kornelis (4/13/2016)

    Ed Wagner (4/13/2016)

    Grumpy DBA (4/12/2016)

    crookj (4/12/2016)

    Bagger

    Vance

    Lance

    Carrier

    Kitty Hawk

    Wright

    Being a former submarine sailor, I'll tell you a word that describes those last two entries... TARGET! 😛

    --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 14, 2016 at 2:23 am

    #1871916

  • RE: Today's Random Word!

    ThomasRushton (4/14/2016)

    Ed Wagner (4/13/2016)

    DonlSimpson (4/13/2016)

    Luis Cazares (4/13/2016)

    Ed Wagner (4/13/2016)

    crookj (4/13/2016)

    jeff.mason (4/13/2016)

    Manic Star (4/13/2016)

    Ed Wagner (4/13/2016)

    ThomasRushton (4/13/2016)

    jeff.mason (4/13/2016)

    Revenant (4/13/2016)

    Hugo Kornelis (4/13/2016)

    djj (4/13/2016)

    crookj (4/13/2016)

    Hugo Kornelis (4/13/2016)

    Ed Wagner (4/13/2016)

    Grumpy DBA (4/12/2016)

    crookj (4/12/2016)

    Bagger

    Vance

    Lance

    Carrier

    Kitty Hawk

    Wright

    Rong

    China

    Grove

    Dictionary

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

    April 14, 2016 at 2:21 am

    #1871914

  • RE: Creating an Index Strategy

    Tava (4/13/2016)

    After rebuilding all the indexes that were used it fixed our issue. SP now returns instantly.

    If you did REBUILDs instead of just REORGANIZEs, then it's very likely that 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)

    April 14, 2016 at 2:17 am

    #1871913

  • RE: Creating an Index Strategy

    It's a funny thing... I no longer reindex or reorganize on my main production box. Log files were getting blown out by the maintenance actions, the database was expanding...

    --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 13, 2016 at 7:54 pm

    #1871898

  • RE: Executing Functions From Table Column

    sarath.tata (4/13/2016)

    I have a table with each row is assigned with a scalar function that returns a nvarchar value.

    I have created a sqlfiddle to help understand my structure and data....

    --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 13, 2016 at 7:16 pm

    #1871894

  • RE: Why have HEAPS?

    Yes. Staging tables... but that's about it. What I've personally encountered is 3rd party database developers that either don't have a clue or believe that the use 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)

    April 13, 2016 at 6:43 pm

    #1871892

  • RE: Loading files in parallel

    140+ files... each file goes to a separate table... etc...

    It sounds more like a version of "poor man's replication" of a whole or nearly whole database. I'd recommend talking 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)

    April 13, 2016 at 6:08 pm

    #1871891

  • RE: How to Monitor the MDF file growth details

    jacksonandrew321 (4/13/2016)

    you may need to trigger the database growth event or set alert for the database.

    How will that help determine the growth over a year? Why not just sample...

    --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 13, 2016 at 8:58 am

    #1871740

  • RE: Trying ot Create Table Dynamically Based on Data in a Column

    Manic Star (4/13/2016)

    If this is for reporting purposes, your best bet is some sort of PIVOT results instead of the dynamic table approach.

    In SSRS, the matrix report handles this...

    --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 13, 2016 at 8:54 am

    #1871737

  • RE: find date value from file name

    Eirikur Eiriksson (4/12/2016)

    Quick thought, look at Ola Hallengren's maintenance scripts, he has a very good clean up process there

    😎

    Isn't that just for backup files?

    --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 13, 2016 at 8:50 am

    #1871733

  • RE: A deadlock issue that killing me dead

    ChrisM@Work (4/13/2016)

    Can you post the execution plans of a couple of those MERGE statements please? Actual, not estimated. If you can, try to get one where the number of rows...

    --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 13, 2016 at 8:44 am

    #1871731

  • RE: Splitting Strings in SQL Server 2016

    Sk1ppy (4/12/2016)

    Thanks; great post! I did have a question about the "failures" using CROSS APPLY vs OUTER APPLY though. Isn't that the expected behavior of using these functions? It seems...

    --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 13, 2016 at 8:22 am

    #1871716

  • RE: Splitting Strings in SQL Server 2016

    LesterF (4/12/2016)

    Great comparison and test metrics. It's great to have off-the-shelf utilities like these.

    However, there is something I think it's worth sharing. Sometimes developers abuse split functions like these for...

    --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 13, 2016 at 8:16 am

    #1871709

  • RE: Master.dbo.SysColumns

    cad.delworth (4/12/2016)

    Jeff: Thanks for the link(s). Still can't get my head around that "From TableA, TableB" syntax :sick:, so I'm afraid the other articles you linked to are near-impossible...

    --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 12, 2016 at 9:16 pm

    #1871574

Viewing 15 posts - 17,866 through 17,880 (of 59,069 total)