Forum Replies Created

Viewing 15 posts - 20,131 through 20,145 (of 59,072 total)

  • RE: Are the posted questions getting worse?

    TomThomson (7/10/2015)

    Eirikur Eiriksson (7/10/2015)

    Spot on Jeff but it doesn't take Chinese though, everyone has heard stories of strange things ordered in French restaurants etc.. Guess the French also use automatic...

    --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 11, 2015 at 12:20 am

    #1811794

  • RE: slow performance

    Grace09 (7/10/2015)

    Jeff, The Compilation Time is from the last time the sql server were rebooted. Thanks.

    Ok... but I need to know what that date and time was, please.

    --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 10, 2015 at 5:02 pm

    #1811786

  • RE: Partitioning and Indexes

    I wouldn't (and haven't) used any of those 3 methods. I'd (and have) do the clustered index by Date (the partitioning column) and the PK. It's going to happen...

    --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 10, 2015 at 12:17 pm

    #1811722

  • RE: Data Loss or Downtime

    I have a 350GB database in my SQLServer based telephone system. If that system goes down, we're toast because it's a critical part of our business to "answer 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)

    July 10, 2015 at 12:02 pm

    #1811712

  • RE: Not able get output because problem with link server

    raghava_tg (7/10/2015)

    i can't post the query , because of restrictions in my Company.

    will post sample tables data and query i am using.

    in the mean while can any one directing...

    --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 10, 2015 at 11:17 am

    #1811702

  • RE: slow performance

    @Grace09,

    Do you have that "Compile Time" that I asked 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)

    July 10, 2015 at 10:10 am

    #1811675

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (7/10/2015)

    SQLRNNR (7/10/2015)

    Sean Lange (7/10/2015)

    Just saw this posted as an explanation to a problem.

    I'm new to SQL already researched in the Chinese do not think swimming on my mistake

    :w00t:

    Whu??

    Where...

    --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 10, 2015 at 10:09 am

    #1811674

  • RE: slow performance

    Grant Fritchey (7/10/2015)

    And the first several chapters of my book on query tuning should help.

    I know Gail's fine articles on performance tuning don't cover the ODBC cursors that are created...

    --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 10, 2015 at 7:52 am

    #1811614

  • RE: slow performance

    In the report itself, you should see a little [+] sign next to the query text. Click that to expand and tell me what the full "Compile Time" is.

    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)

    July 9, 2015 at 6:27 pm

    #1811475

  • RE: slow performance

    Grace09 (7/9/2015)

    I have a sql server 2008 r2 on windows server 2008 r2. Users have been complaining about the slow performance. from the task manager, the memory utilize at about...

    --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 9, 2015 at 3:04 pm

    #1811458

  • RE: Trigger an Email of an SSRS Report from an SSIS Package

    Stan Kulp-439977 (7/9/2015)

    SilentMike (7/9/2015)

    Hi Stan

    Really useful article, thanks.

    I have a question around the long term use of this solution. I've done a bit of testing and the subscription still 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)

    July 9, 2015 at 8:33 am

    #1811337

  • RE: Backups

    BL0B_EATER (7/9/2015)

    I follow the words of Paul Randal...

    "The key point when planning a backup strategy is not to think about what backups you want to take – think about what...

    --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 9, 2015 at 8:29 am

    #1811335

  • RE: When to mess with CPU affinity?

    derek.colley (7/10/2012)

    In the process of tuning up and fixing the obvious deficiencies, only been here a couple of weeks so far. There's no shortage of targets 🙂 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)

    July 8, 2015 at 7:31 pm

    #1811160

  • RE: Backups

    The transaction log backups should never longer than the max amount of data that you willing allow to lose. Once every 15 minutes is just fine and it's 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 8, 2015 at 6:50 pm

    #1811158

  • RE: alwayson

    giri10488 (7/6/2015)

    what is alwayson high availability in detail & how its works?

    pls reply

    There's an incredible website that, apparently, no one ever uses that has all the detail you'll need 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)

    July 8, 2015 at 5:54 pm

    #1811157

Viewing 15 posts - 20,131 through 20,145 (of 59,072 total)