Forum Replies Created

Viewing 15 posts - 20,071 through 20,085 (of 59,072 total)

  • RE: Presenting Data

    Steve Jones - SSC Editor (7/20/2015)

    dietztm (7/20/2015)

    Why not learn Power Pivot too? It's not THAT hard. I know that many of us are allergic to Excel (from an end-user perspective)...

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

    July 20, 2015 at 5:06 pm

    #1813760

  • RE: Need login help to send files to

    jonathanm 4432 (7/20/2015)

    John,

    Maybe I am doing something wrong with it. I need to copy the files that each section outputs to a server which has a log on and 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)

    July 20, 2015 at 2:30 pm

    #1813745

  • RE: Numeric/Negative Check

    Naina_11 (7/17/2015)

    Gosh... I am sorry i am not ignoring... i trying to find some simpler way if any else i have your suggestion in store. Looking for something easier as...

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

    July 20, 2015 at 2:26 pm

    #1813743

  • RE: Linked AS400 stopped working

    btjtaylor (7/14/2015)

    I was working on this problem for a client and came across this thread. I experienced the issue when using a 2-node SQL 2012 cluster, when the clustered instance's...

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

    July 20, 2015 at 12:45 pm

    #1813721

  • RE: Records per hour within a time span

    daveb-840383 (6/22/2010)

    Let me try to explain the situation a little better.

    If a user #1 is connected from 1:00 PM - 6:00 PM

    and user #2 is connected from 1:01 PM -...

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

    July 20, 2015 at 12:17 pm

    #1813720

  • RE: Presenting Data

    GoofyGuy (7/20/2015)

    The problem with BI is that "Business Intelligence" is frequently an oxymoron. No matter what the data is or how it is presented, the people that it's all provided/presented...

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

    July 20, 2015 at 11:17 am

    #1813707

  • RE: Presenting Data

    Steve Jones - SSC Editor (7/20/2015)

    I'm not saying that any report is good. Or that all the reports you come up with will be used or well received. I'm not...

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

    July 20, 2015 at 11:16 am

    #1813705

  • RE: Presenting Data

    TomThomson (7/20/2015)

    Jeff Moden (7/18/2015)

    This is the most important...

    One of the best things you can do as a developer or DBA is ensure you can write efficient queries that assemble 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)

    July 20, 2015 at 11:08 am

    #1813701

  • RE: Records per hour within a time span

    drew.allen (7/20/2015)

    Jeff Moden (7/18/2015)

    Why does everyone think that a post is only for the OP? Five years old or not, additional information never hurts.

    The vast majority of the 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)

    July 20, 2015 at 10:56 am

    #1813698

  • RE: Indexes with more writes than reads

    Ah. Ok. Now I understand. Thanks for the feedback.

    Yes... Your last paragraph above is indeed a problem. It would appear that someone knew of the performance...

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

    July 19, 2015 at 9:29 pm

    #1813565

  • RE: Distinct performance

    berki (7/19/2015)

    Yep - nothing else is running and there's no blocking I can remove the transaction commit statements but still the same.

    I've created a new database on local storage, same...

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

    July 19, 2015 at 8:37 pm

    #1813558

  • RE: Distinct performance

    berki (7/19/2015)

    When I've created a table filled it with data then select distinct data from it, it takes hours and is still running up to 17 hours.

    Removing the distinct returns...

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

    July 19, 2015 at 10:01 am

    #1813546

  • RE: Indexes with more writes than reads

    lmarkum (7/18/2015)

    Jeff, as I identify long running queries I come across tables with too many indexes. I examine the usage of those indexes with the usage_stats DMV and find...

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

    July 19, 2015 at 9:55 am

    #1813545

  • RE: Query help to generate relationship

    mxy (7/18/2015)

    thanks for your reply Jeff. Data is correct,

    Ex: BOFA has multiple share holders and it can hold shares on its own account.

    If BOFA has a child as bank A,B

    Bank...

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

    July 19, 2015 at 9:13 am

    #1813544

  • RE: Query help to generate relationship

    mxy (7/18/2015)

    Hello,

    I am working on a query to generate parent child hierarchy from a table.

    Table has below records.

    Col1ID Col2Parent Col3Child

    1 ...

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

    July 18, 2015 at 7:49 pm

    #1813532

Viewing 15 posts - 20,071 through 20,085 (of 59,072 total)