Forum Replies Created

Viewing 15 posts - 25,951 through 25,965 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/24/2011)

    Stefan Krzywicki (5/24/2011)

    Plus, if the person gets undercover help and succeeds, they're going to be asked to do more that they're going to need help...

    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

    May 24, 2011 at 11:42 am

    #1329274

  • RE: KILLED/ROLLBACK thread in Activity Monitor

    If you restart SQL, the rollback will continue after the restart and, depending on the edition the DB could be offline during the rollback.

    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

    May 24, 2011 at 9:37 am

    #1329169

  • RE: 40GB Log with Scheduled Backups

    Vertigo44 (5/24/2011)

    There is also 'Remove unused space from database files and shrink db with it grows beyond 50 MB?? (Does that sound right? 50 MB?)...

    There's your database shrink. Turn that...

    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

    May 24, 2011 at 7:46 am

    #1329069

  • RE: 40GB Log with Scheduled Backups

    Vertigo44 (5/24/2011)

    My question is this... In SQL Server 2000 does a scheduled backup also run a DBCC Shrink?

    No.

    If the log file is reducing in size you either have autoshrink on,...

    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

    May 24, 2011 at 7:32 am

    #1329051

  • RE: Tools to Measuring Query Performance and Implications

    Grant Fritchey (5/24/2011)

    Having had really horrific procedures that had compile time problems, I used to sweat that when I saw the size of a query exceed a certain point, but...

    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

    May 24, 2011 at 7:22 am

    #1329044

  • RE: Content Missing

    It's not the stairway series, but if you're interested in indexes:

    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

    May 24, 2011 at 7:22 am

    #1329042

  • RE: Can't turn snapshot isolation on

    Alter database needs exclusive database access, so it will wait until all other connections to the DB are closed.

    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

    May 24, 2011 at 6:54 am

    #1329012

  • RE: Tools to Measuring Query Performance and Implications

    Abrar Ahmad_ (5/24/2011)

    So my point was that the DMVs may also suffer from some latency to update new information?

    Not noticeably. The DMVs just expose internal memory structures, they're not real...

    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

    May 24, 2011 at 6:46 am

    #1329007

  • RE: Tools to Measuring Query Performance and Implications

    colin.Leversuch-Roberts (5/24/2011)

    I never truly understand this fixation with clearing cache(s)

    Me neither. I prefer to run queries more than once and discard the first results so as to get something close...

    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

    May 24, 2011 at 6:43 am

    #1329004

  • RE: Memory

    DugyC (5/24/2011)

    I'm not at all knowledgeable in the subject, but from reading this it appears to me that they are quite different.

    "Plan Cache" is used to cache the compiled 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

    May 24, 2011 at 4:55 am

    #1328942

  • RE: supports dbmirror

    Standard and Enterprise edition only. Standard edition supports synchronous mirroring, Enterprise supports synchronous and asynchronous mirroring.

    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

    May 24, 2011 at 4:17 am

    #1328921

  • RE: SQL Service Broker (Message receiving problem)

    Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1113777-149-1.aspx

    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

    May 24, 2011 at 2:00 am

    #1328867

  • RE: Statistics for performance

    Create a job that runs update statistics with full scan on those tables. Schedule it to run as often as you find necessary.

    Auto update stats only kicks in after a...

    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

    May 24, 2011 at 1:58 am

    #1328865

  • RE: Are the posted questions getting worse?

    LutzM (5/23/2011)

    Regarding the specific situation: it might be better for the person in question to officially ask for support. Try to deal with the situation "undercover" would just increase 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

    May 23, 2011 at 11:41 pm

    #1328840

  • RE: Tools to Measuring Query Performance and Implications

    Syed Jahanzaib Bin hassan (5/23/2011)

    Use DTA for queries optimizations ...

    If you use DTA, do not simply accept its recommendations. Test them, implement the ones that make a difference.

    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

    May 23, 2011 at 11:40 pm

    #1328838

Viewing 15 posts - 25,951 through 25,965 (of 49,552 total)