Forum Replies Created

Viewing 15 posts - 196 through 210 (of 234 total)

  • RE: DB Maint Plan not automatically clearning TRN''''s

    check that the maintenance plan is actually completing and not failing on the last (or only) step.  It may be that the backups are there; but the plan is failing and...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Reporting Services Exception System.IO.DirectoryNotFoundException

    Sorry, but I suspected it could not find g:\ because g:\ was not there...  I would still question permissions of the device; but I guess you have done that, too....

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Applying SP4 for SQL2K

    Thanks for the tip!  I think I would have done it otherwise; although log shipping was broken here when I arrived, and SP4 was already installed.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Combining ALL databases into one big one?

    Ideally they would be more than "combined", they would be designed to be one database.  Eliminating "stovepipe application" is (or can be) a good thing; but if you are going...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: SQL query to create test data

    So, that is a solution for you; but it is not generic... and not all databases have data in them to query, at some point in the life-cycle the database...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Reporting Services Exception System.IO.DirectoryNotFoundException

    Do you physically have a G:\ drive?

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Installing Reporting Server for "fail-over" operation

    Turns out that this is a very clever configuration to allow Standard Edition to be installed in a cluster configuration.  According to Microsoft in order to implement a "scale-out" configuration...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: SQL query to create test data

    probably because this doesn't have anything to do with business intelligence... and it is a problem/issue/situation that everyone has - and there is usually no solution short of just putting...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Annoying ad

    I don't care what anybody says... that ad is about the neatest one I have ever seen.  Makes me want to go back to having sites just to use the...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Hyperthreading Question

    Thank you David Scotland for an excellent link.  Sure seems like there is no conclusive answer without testing under load - which is often difficult to get the load in...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Frequent Trans Log Backups Vs Autogrow

    autogrow can cause unexpected fragmentation, both internal and external.  if you have a maintenance plan that regularly rebuilds indices, and an external program such as Diskeeper that is scheduled to...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Challenge: check my cost figures; SQL Server 2x Oracle??

    Here is a bit of an equalizer perhaps...

    MULTICORE

    Multicore processors, which consist of multiple processing execution units or “cores” on one chip, are seen as a promising way...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: When is the appropriate time to fire t-logs backup?

    In my experience (not with just SQL Server), untested backups are worthless as much as 80% of the time.  And testing a backup with a restore or recovery needs more than casual...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: need help Installing SSIS

    if you install the trial of the full product.  not express.  You need to also install the tools, which used to be on the second CD - although I have...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Returning to SQL Server 2000 after Upgrading to 2005

    and don't forget to compliment her hair!

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

Viewing 15 posts - 196 through 210 (of 234 total)