Forum Replies Created

Viewing 15 posts - 27,196 through 27,210 (of 49,552 total)

  • RE: Difference between Truncateonly and NoTruncate

    On log backups, TruncateOnly is not supported any longer, but NoTruncate most certainly is.

    Truncate Only: Do not back the log up to disk. Do truncate the log. Not valid in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 11:15 am

    #1302020

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/22/2011)

    <groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's a bad...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 11:05 am

    #1302012

  • RE: Execution Query Cost vs Profiler stats

    jonwolds 8288 (3/22/2011)

    How can the costs be estimates in the actual execution plan?

    Because they are calculated at optimisation time only.

    I thought the actual plan was the plan it used...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 11:04 am

    #1302010

  • RE: Rebuild/Reorg Indexes

    If a checkDB of a restored database succeeds, you know that the production DB was free of corruption errors at the time the backup was taken. Allocation structures are backed...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 11:03 am

    #1302009

  • RE: Execution Query Cost vs Profiler stats

    The costs are estimates, there are a number of things that can make them wrong, cardinality inaccuracies being one of the more common/.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 9:57 am

    #1301963

  • RE: What is recovery indexes?

    I think this has a bit on covering indexes, iirc http://www.sqlservercentral.com/articles/Indexing/68636/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 9:53 am

    #1301957

  • RE: Rebuild/Reorg Indexes

    Please post new questions in a new thread. Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 9:46 am

    #1301949

  • RE: Reorganizing Indexes in 2008 R2

    Ninja's_RGR'us (3/22/2011)

    GilaMonster (3/22/2011)

    Not one of Michelle's. There are others that do, do not have links handy.

    Alright, I was wondering if you have taken that task on and had something tested.

    I...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 8:05 am

    #1301889

  • RE: Reorganizing Indexes in 2008 R2

    Not one of Michelle's. There are others that do, do not have links handy.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 7:54 am

    #1301881

  • RE: Reorganizing Indexes in 2008 R2

    One option (far from the only one that exists) http://sqlfool.com/2010/04/index-defrag-script-v4-0/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 7:50 am

    #1301877

  • RE: attache database problem

    Most likely because the account that SQL is running under does not have permissions to that folder.

    Move the files (mdf and ldf) to the SQL data folder (whereever that was...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 5:09 am

    #1301791

  • RE: Backup Corrupted

    Then you are seriously in trouble, as that backup is not going to be restorable, and there's no 'continue after error' option on SQL 2000.

    Is there no other backup at...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 5:06 am

    #1301790

  • RE: Need to perform a RESTORE!

    Vertigo44 (3/22/2011)

    However, I did discover that the jobs that were created to run full and log backups were also doing a cleanup after 4 days! This is why I came...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 5:04 am

    #1301789

  • RE: Does Estimated Subtree Cost Provide (near)Accurate Measurement?

    Marvin Maralit (3/22/2011)

    Actually I'm focusing on the duration bro. You mean every time I tune my queries, I should wait for them to be finished in order for me...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 4:47 am

    #1301780

  • RE: Database Integrity

    Please run the following and post the full and complete results. Without seeing the errors I can't recommend a route to fix.

    DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS

    This may be worth...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 22, 2011 at 4:45 am

    #1301779

Viewing 15 posts - 27,196 through 27,210 (of 49,552 total)