Forum Replies Created

Viewing 15 posts - 17,446 through 17,460 (of 59,067 total)

  • RE: Strange Performance Issue

    ChrisM@Work (6/14/2016)

    davidlester.home (6/14/2016)

    I did eventually get this to work, though it makes little sense. It turns out that dropping all the indexes on the table was the answer. With indexes...

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

    June 16, 2016 at 8:32 am

    #1885421

  • RE: copy using xp_cmdshell

    Mr J (1/20/2010)

    I find that running batch files through xp_cmdshell is a much better way to perform dos operations, also you might want to look into forfiles.

    Kindred spirit here on...

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

    June 16, 2016 at 8:25 am

    #1885417

  • RE: Interview Questions

    ScottPletcher (6/16/2016)

    Jeff Moden (6/15/2016)

    Sergiy (6/15/2016)

    Actually, your "simple question" does not have a correct answer.

    The only correct answer would be a question in response.

    Probably, more that one question in response.

    Until your...

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

    June 16, 2016 at 8:22 am

    #1885414

  • RE: Database Documentation

    HappyGeek (10/21/2015)

    Not quite sure this is the right place for this, forgive me if I have it wrong. :blush:

    To rapidly document a database I open Excel, start PowerPivot and...

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

    June 16, 2016 at 1:31 am

    #1885311

  • RE: Database Documentation

    Alexandre Araujo (6/15/2016)

    what is the relevance with sql 16 ?

    I would say "None" and "Why is that important"?

    Edit... ah... now I understand the question. It's because it was posted...

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

    June 16, 2016 at 1:20 am

    #1885310

  • RE: Stretch Pricing

    Sounds like the oldest trick in the book... "Give them the razor... and then sell them lots of blades." 😀

    Shifting gears a bit...

    From the article:

    Less data should mean much better...

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

    June 16, 2016 at 1:18 am

    #1885309

  • RE: Introduction to U-SQL and Azure Data Lakes

    Great article! Thanks for taking the time to write it.

    Shifting gears and without having anything to do with the article, I think U-SQL only being available to the cloud...

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

    June 16, 2016 at 12:33 am

    #1885307

  • RE: import from CSV/EXCEL and insert/update into SQL which is backend for payroll software

    K. Glad that works for you. I was also going to try to show you how you could import the Excel file without having to convert it 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)

    June 15, 2016 at 6:52 pm

    #1885299

  • RE: Interview Questions

    Sergiy (6/15/2016)

    Jeff Moden (6/15/2016)

    An interview is the one place where volunteering information can do nothing but good... if you know what you're talking about. When someone asks a simple...

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

    June 15, 2016 at 6:38 pm

    #1885298

  • RE: Interview Questions

    Sergiy (6/15/2016)

    Actually, your "simple question" does not have a correct answer.

    The only correct answer would be a question in response.

    Probably, more that one question in response.

    Until your requirements become clear.

    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)

    June 15, 2016 at 6:10 pm

    #1885296

  • RE: Interview Questions

    GSquared (6/15/2016)

    And not outrage. Read what you want to into my response. Joe Celko would be proud of you.

    Gosh Gus, who peed in your cheerios today? You...

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

    June 15, 2016 at 3:39 pm

    #1885271

  • RE: Interview Questions

    Eric M Russell (6/15/2016)

    ScottPletcher (6/15/2016)

    Eric M Russell (6/15/2016)

    Jeff Moden (6/14/2016)

    Eric M Russell (6/14/2016)

    You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How...

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

    June 15, 2016 at 3:36 pm

    #1885270

  • RE: Function to convert a datetime value into a harvest season year

    GSquared (6/14/2016)

    I just tested a Calendar table version against the UDFs defined here.

    Calendar table was consistently about 10X faster.

    Can you post your test 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)

    June 15, 2016 at 9:06 am

    #1885187

  • RE: Function to convert a datetime value into a harvest season year

    joe-584802 (6/14/2016)

    Thanks for the improvement Lynne, I'm guessing table valued functions are more efficient than in-line scalar valued functions?

    Yes and no. There are two types of table valued functions...

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

    June 15, 2016 at 9:03 am

    #1885186

  • RE: Interview Questions

    Lynn Pettis (6/15/2016)

    The only reason I don't think I would not make it through one of your interviews is that no matter how much you assure me that there are...

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

    June 15, 2016 at 8:41 am

    #1885175

Viewing 15 posts - 17,446 through 17,460 (of 59,067 total)