Forum Replies Created

Viewing 15 posts - 20,161 through 20,175 (of 59,098 total)

  • 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

  • RE: Aggrigation of 200 Mil Data records

    sudhirnune (7/7/2015)

    Hi All,

    We are having a requirement to Aggregate the data and create LY, CY data across 5 Metrics.

    the Volume of Data will be 200 Mil - 250 Mil

    Server Configuration:

    Memory:...

    --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 3:32 pm

    #1811146

  • RE: A Case FOR Cursors...

    patrickmcginnis59 10839 (7/8/2015)

    Jeff Moden (7/8/2015)

    Specifically, the following seemed to be a whole lot condescending on your part...

    the folks here aren't database server implementers, they are database server users, and 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 8, 2015 at 3:00 pm

    #1811140

  • RE: Problems importing CSV files using SSIS.

    Orlando Colamatteo (7/7/2015)

    Your argument against XML, JSON, even CSV with delimiters available on a 101 keyboard rings very similar to the assembler programmer that used to sit down the hall...

    --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 11:52 am

    #1811085

  • RE: A Case FOR Cursors...

    patrickmcginnis59 10839 (7/6/2015)

    Jeff Moden (7/6/2015)

    patrickmcginnis59 10839 (7/6/2015)

    Again I am not sure why Oracle can make their PL/SQL using cursors as fast as set based operations and MS cannot. Cursors 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)

    July 8, 2015 at 11:46 am

    #1811080

Viewing 15 posts - 20,161 through 20,175 (of 59,098 total)