Forum Replies Created

Viewing 15 posts - 16,726 through 16,740 (of 49,552 total)

  • RE: How do I fix Damaged allocation pages

    Got a clean backup?

    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

    September 10, 2012 at 9:33 am

    #1535770

  • RE: queries running faster after cached in the query plan

    No. Only when the data changes are sufficient to trigger a statistics update, as stats updates invalidate cached plans.

    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

    September 10, 2012 at 4:40 am

    #1535607

  • RE: What is the meaning of view is not schema bound?

    Read up on the requirements for indexing a view, there are a lot of them.

    This particular one (as Books Online would have shown) say that the view was not created...

    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

    September 10, 2012 at 4:38 am

    #1535603

  • RE: queries running faster after cached in the query plan

    The latter, assuming that the query continues to process the same number of rows each time.

    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

    September 10, 2012 at 4:31 am

    #1535599

  • RE: Poor Performance

    Maybe, maybe not. Depends if the cause of the problem is stale stats. If not, they'll do nothing or slow things down.

    Don't try 'shotgun' tuning. Find the problem, fix the...

    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

    September 10, 2012 at 3:50 am

    #1535587

  • RE: Need help on select sceanrio

    I'd say it's your job as consultant to advise the client against this approach.

    There's no way to do this without dynamic SQL. You need to account for the security risks,...

    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

    September 10, 2012 at 2:48 am

    #1535568

  • RE: Poor Performance

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    September 10, 2012 at 1:57 am

    #1535559

  • RE: Need help on select sceanrio

    Work, yes it will. A good idea, no, very much not.

    It's a security risk and it smells of bad design. Why do you want to go this route?

    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

    September 10, 2012 at 1:55 am

    #1535558

  • RE: The index may be corrupt. Run DBCC CHECKTABLE to verify consistency.

    No issues, as I said SQL can recreate it if necessary.

    Yes, drop any stats that were mentioned in errors.

    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

    September 9, 2012 at 10:25 am

    #1535484

  • RE: The index may be corrupt. Run DBCC CHECKTABLE to verify consistency.

    Is the statistic _WA_Sys_OPERATION_SEQ_NUM_10566F31 still present?

    If so, maybe drop it. SQL can always recreate it if it needs to.

    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

    September 9, 2012 at 9:34 am

    #1535480

  • RE: Indexing??? Help Needed

    Take a read through these:

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    September 9, 2012 at 8:09 am

    #1535476

  • RE: Would a smaller number of VLFs in the log speed up the redo phase of recovery of a mirror snapshot?

    Perhaps. Depends just how many VLFs you're talking about.

    You've read Kimberly Tripp's blog post on transaction log throughput?

    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

    September 9, 2012 at 8:09 am

    #1535475

  • RE: The index may be corrupt. Run DBCC CHECKTABLE to verify consistency.

    And, did you run CheckTable as the error said? If so what's the output?

    If not, please run this and post the full and unedited results.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS,...

    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

    September 9, 2012 at 8:08 am

    #1535474

  • RE: Move extents between files

    Probably A2 and A3 become full and A is NOT marked as empty (it's not empty, it can't be marked that way)

    Try it and see.

    Btw, why are you trying to...

    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

    September 9, 2012 at 5:41 am

    #1535461

  • RE: Move extents between files

    The only way that will definitely work, yes.

    You can try stuff like rebuilding indexes and hoping SQL balances out the allocations, but it's pot luck.

    If you're out of space, get...

    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

    September 8, 2012 at 11:39 am

    #1535415

Viewing 15 posts - 16,726 through 16,740 (of 49,552 total)