Forum Replies Created

Viewing 15 posts - 16 through 30 (of 78 total)

  • RE: Partitioned Views

    darshan (12/6/2013)

    Hi,

    Consider the following scenario:

    1. Application x has a few transaction tables as very huge tables say tables t1, t2, t3, etc.

    2. Application is only in maintenance mode and no...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    December 9, 2013 at 3:33 am

    #1671853

  • RE: Partitioned Views

    peter-757102 (12/5/2013)

    You can create multiple filtered statistics yourself that do not overlap in key range, this way you can get multiple blocks of 200 entry statistics, even on a single...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    December 9, 2013 at 3:29 am

    #1671852

  • RE: Improving SSIS Update Performance

    Thanks to all for your comments 🙂

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    November 1, 2013 at 12:13 am

    #1663336

  • RE: Improving SSIS Update Performance

    Leo Peysakhovich (10/31/2013)

    Thanks, nice article. Few comments:

    1. Threads can interfere with each other if there are records on the same pages. And this will be a reality unless split is...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    November 1, 2013 at 12:10 am

    #1663335

  • RE: SSAS Reporting Action

    Patrick Womack (12/9/2011)

    Brian,

    The answer to your report parameter question is in the link your provided. Look at Figure 7 - Supply Report Parameters.

    Hi Patrick

    Thanks for your feedback! I have...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    December 15, 2011 at 2:12 am

    #1421784

  • RE: SSAS Reporting Action

    Patrick Womack (12/8/2011)

    For server name enter just the name of the server without any path or aspx page.

    For report path enter: ReportServer?/System/Finance Reports/Invoice

    Thanks Patrick for your help. In fact now...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    December 9, 2011 at 12:51 am

    #1419095

  • RE: SSAS Reporting Action

    OK made progress, not surely what I did BUT the reporting option is now visible in both SSMS and Excel, however I clearly now have a problem with the report...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    December 6, 2011 at 9:23 am

    #1417467

  • RE: Statistics

    SQLkiwi (8/1/2011)

    brian118 (8/1/2011)

    Found this white paper. related to SQL Server 2000.

    To avoid long term maintenance of unused statistics, SQL Server 2000 ages the automatically created statistics (only those that...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 1, 2011 at 11:57 pm

    #1361955

  • RE: Statistics

    Ninja's_RGR'us (8/1/2011)

    brian118 (8/1/2011)

    Ninja's_RGR'us (8/1/2011)

    Well for sure editing an index could cause this.

    This is the first I hear of stats being dropped. Tho I can understand the decision behind the...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 1, 2011 at 8:34 am

    #1361581

  • RE: Statistics

    ALZDBA (8/1/2011)

    So, where/how does it keep track if stats are no longer being used ??

    SELECT quotename(object_schema_name(OBJECT_ID)) + '.' + quotename(object_name(OBJECT_ID)) as ObjectName

    , quotename(name)...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 1, 2011 at 8:19 am

    #1361566

  • RE: Statistics

    Ninja's_RGR'us (8/1/2011)

    Well for sure editing an index could cause this.

    This is the first I hear of stats being dropped. Tho I can understand the decision behind the behavior.

    Other than...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 1, 2011 at 8:17 am

    #1361564

  • RE: Statistics

    Ninja's_RGR'us (8/1/2011)

    That actually can't happen. The restore of a backup is a perfect copy of the DB (including index and stats).

    Either the backup is older than the db itself...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 1, 2011 at 7:48 am

    #1361537

  • RE: Statistics

    Ninja's_RGR'us (8/1/2011)

    Not that I know off. The real quesion is why do you care about that?

    Each stats is very small on the HD.

    One of our clients restored...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 1, 2011 at 7:09 am

    #1361517

  • RE: eliminating comma from a string

    scottichrosaviakosmos (5/9/2011)

    ok this will work fine to single action, like here for removing commas. but what if i have some other special character to remove then again i have to...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 9, 2011 at 5:46 am

    #1321649

  • RE: Importing Excel data to a table using SSIS

    drew.. (5/8/2011)

    Hi all

    I am new to BI and I need some help. I have seen similar links to my question but they don't seem to work so please provide a...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 9, 2011 at 12:45 am

    #1321562

Viewing 15 posts - 16 through 30 (of 78 total)