Forum Replies Created

Viewing 15 posts - 20,101 through 20,115 (of 59,098 total)

  • 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

  • RE: Regular activities of SQL DBA (L1 person).....

    Sgar... (7/21/2011)

    The person as L1 support what will be the regular activities as soon as he goes to office ? what will be the regular issues you will face?

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

    July 18, 2015 at 7:29 pm

    #1813531

  • RE: Indexes with more writes than reads

    lmarkum (7/17/2015)

    I have inherited a database that is over-indexed, i.e. there are sometimes 10-20 indexes on a table. The performance is at times not great due to blocking from...

    --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:08 pm

    #1813530

  • RE: SQL Server 2008 Ran out of Disk Space

    Peter19898 (7/17/2015)

    Hi

    One of our SQL servers ran out of disk space and we received an error stating that the transaction log file was full for one of our Sharepoint content...

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

    #1813529

  • RE: Presenting Data

    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 from a variety...

    --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 12:28 pm

    #1813514

Viewing 15 posts - 20,101 through 20,115 (of 59,098 total)