Forum Replies Created

Viewing 15 posts - 14,056 through 14,070 (of 49,552 total)

  • RE: database page level corruptions?

    I think you're going to have to restore an older backup. That looks too damaged to be useful.

    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 4, 2013 at 2:55 am

    #1592926

  • RE: Identifying performance issues using Profiler trace

    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

    March 4, 2013 at 2:18 am

    #1592914

  • RE: CPU considerations for multiple instances

    Typically I just let Windows balance them out via the normal scheduling. If you want to limit, rather don't use processor affinity (and please don't set maxdop to 1).

    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 4, 2013 at 12:55 am

    #1592889

  • RE: Group by and Where clause

    http://sqlblog.com/blogs/paul_white/archive/2012/03/12/fun-with-aggregates.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

    March 4, 2013 at 12:43 am

    #1592888

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    GilaMonster (3/3/2013)

    Welsh Corgi (3/3/2013)

    How do you check what the rollback session is waiting for?

    GilaMonster

    Same way you check what any session is waiting for, sys.dm_exec_requests

    If you believe 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

    March 4, 2013 at 12:36 am

    #1592885

  • RE: SQL Server Express and SQL Server Agent?

    SQL Server Express does not support SQL Agent.

    By installed, do you mean the service is there?

    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 3, 2013 at 3:40 pm

    #1592817

  • RE: Attach Database Error after moving MDF

    Check the permissions, the error is OS error 5, that is a permission problem.

    Could be that in the detach the permissions on the files were changed, I have seen 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

    March 3, 2013 at 3:30 pm

    #1592815

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    How do you check what the rollback session is waiting for?

    Same way you check what any session is waiting for, sys.dm_exec_requests

    If you believe that Kill with the statusOnly...

    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 3, 2013 at 2:16 pm

    #1592809

  • RE: unexplained deadlock

    Drop the nolock. It has no effect on a table that is the target of an update, that's documented. It's also plain bad practice in most cases. Optimise the query,...

    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 3, 2013 at 1:56 pm

    #1592806

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    It does work, it's the correct and only way to get the rollback status and progress.

    Check what the rolling back session is waiting for.

    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 3, 2013 at 1:53 pm

    #1592802

  • RE: Attach Database Error after moving MDF

    The SQL Server service does not have permissions on the log file or the directory it's in. Check the permissions, ensure that SQL Server service has full control over both...

    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 3, 2013 at 1:30 pm

    #1592797

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    You gave the command in your first post. KILL <spid> WITH StatusOnly

    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 3, 2013 at 1:08 pm

    #1592791

  • RE: fetch tables most often queried

    Just bear in mind that index_usage_stats only has info from the last time the database was started. If you have autoclose on or take the DB offline for any reason,...

    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 3, 2013 at 11:38 am

    #1592782

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    GilaMonster (3/3/2013)

    Welsh Corgi (3/3/2013)

    GilaMonster (3/3/2013)

    Welsh Corgi (3/3/2013)

    Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure,...

    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 3, 2013 at 11:16 am

    #1592779

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    GilaMonster (3/3/2013)

    Welsh Corgi (3/3/2013)

    Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure, backup. Killing 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

    March 3, 2013 at 10:54 am

    #1592777

Viewing 15 posts - 14,056 through 14,070 (of 49,552 total)