Forum Replies Created

Viewing 15 posts - 25,261 through 25,275 (of 49,552 total)

  • RE: Help in query optimization

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    July 1, 2011 at 1:14 am

    #1346889

  • RE: Question on backup of sql database

    GilaMonster (6/30/2011)

    Re backups, you need to back the log shipping primary up. You can run full and diff backups. You just cannot have another job as well as the log...

    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

    July 1, 2011 at 1:13 am

    #1346888

  • RE: Runaway Transaction Log Growth

    Something that happened before those were run cleared the log. You should be able to shrink it to a sensible size now (once-off shrink)

    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

    June 30, 2011 at 4:52 pm

    #1346811

  • RE: Runaway Transaction Log Growth

    DBCC SQLPERF(LogSpace)?

    Can you put a job in that monitor both (log_reuse_wait and SQLPerf(LogSpace) regularly (say every 30 min, or as often as you take log backups)?

    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

    June 30, 2011 at 3:48 pm

    #1346795

  • RE: Runaway Transaction Log Growth

    What's the log_reuse_wait_desc?

    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

    June 30, 2011 at 3:32 pm

    #1346789

  • RE: relationship between statistics and indexes

    Dropping the index will drop the stats associated with that index.

    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

    June 30, 2011 at 12:05 pm

    #1346680

  • RE: Index/locking hints - how often are they necessary?

    dean.g (6/30/2011)

    We have members of the team who are utterly convinced they need to use (nolock) with every single query they write or we'll get too much table locking. ...

    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

    June 30, 2011 at 9:59 am

    #1346640

  • RE: How to find highest paying two employee for each dept

    Indeed. To fix, flip the sort order around and flip the comparison.

    SELECT EmpName, Salary, Dept FROM (

    SELECT EmpName,Salary,Dept, ROW_NUMBER() OVER(PARTITION BY Dept ORDER BY Salary DESC) AS Row,

    FROM tblGetEmp) Sub

    WHERE...

    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

    June 30, 2011 at 9:50 am

    #1346636

  • RE: Runaway Transaction Log Growth

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    June 30, 2011 at 6:43 am

    #1346494

  • RE: Change FillFactor back to 0 on DB

    Yup, but currently it doesn't, nor does the page splits/sec, nor does the extended event.

    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

    June 30, 2011 at 6:39 am

    #1346489

  • RE: DBCC CHECKDB errors

    Interesting set of errors.

    Try dropping, then recreating the clustered index on MultiSpuDownloads and dropping and recreating the nonclustered index (ID 3) on MultiSpuEndpointProperties

    Then run CheckDB again (with the same...

    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

    June 30, 2011 at 6:37 am

    #1346488

  • RE: Attach in nonrecovery mode

    No, you can't attach a DB and leave it recovering. To start a log shipping setup, you need to restore a full backup with norecovery.

    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

    June 30, 2011 at 6:35 am

    #1346483

  • RE: Log file shrink

    Maintenance plans and auto_shrink are the two other places. When you find the shrink you'll be removing it, right?

    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

    June 30, 2011 at 6:33 am

    #1346482

  • RE: logs taken every 15 mins - which tran logs do i use in a full restore?

    Start with the earliest of the options, SQL will tell you if the log backup is not needed.

    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

    June 30, 2011 at 6:30 am

    #1346479

  • RE: Change FillFactor back to 0 on DB

    george sibbald (6/30/2011)

    so is the term page-split a misnomer? Is it in fact including new page allocations not caused by a page split?

    Page split = allocation of a new...

    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

    June 30, 2011 at 6:25 am

    #1346477

Viewing 15 posts - 25,261 through 25,275 (of 49,552 total)