Forum Replies Created

Viewing 15 posts - 19,636 through 19,650 (of 49,552 total)

  • RE: Task was forced to yield

    Do some monitoring and correlate query execution with the error log events.

    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, 2012 at 8:28 am

    #1462748

  • RE: Task was forced to yield

    Find what?

    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, 2012 at 7:33 am

    #1462703

  • RE: In replication, how to delete Clustered and Primary key constraint in publisher database

    You'll have to remove the table from the publication, make the changes and then add it back 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, 2012 at 7:01 am

    #1462674

  • RE: dmx help plz

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1270783-147-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

    March 22, 2012 at 6:39 am

    #1462657

  • RE: dmx \

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1270783-147-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

    March 22, 2012 at 6:38 am

    #1462656

  • RE: Alter Index... Sort_In_Tempdb On

    Please post new questions in a new thread.

    Sort in TempDB option is not about log space used. It just means that the 20% or so sort space is allocated from...

    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, 2012 at 6:37 am

    #1462655

  • RE: Stack Dump Error?

    Bugs, consistency errors, user-requested dumps, hung schedulers, probably a few more. Open up the text dump file and have a read through.

    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, 2012 at 6:35 am

    #1462654

  • RE: sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

    Because they don't know better?

    There are some things that can't be parameterised - IN lists, table and column names, however ignoring those you should always try to write parameterised queries...

    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, 2012 at 6:33 am

    #1462651

  • RE: Handling Deadlocks

    Without the code and the deadlock graph it's impossible to give any useful advice.

    Get the deadlock graph (via traceflag 1222 or via the extended events system health session), look 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, 2012 at 4:55 am

    #1462611

  • RE: How can I simulate a deadlock ??

    mc2601 (3/22/2012)

    Hi Monster~~

    THanks for your reply~ can it be more details, I don't know why my Adventureworks don't have

    person.persons

    Pick any 2 tables, doesn't matter which ones.

    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, 2012 at 4:51 am

    #1462607

  • RE: How can I simulate a deadlock ??

    Window 1:

    Begin tran

    Update Person.Persons

    Waitfor delay 10 seconds

    Select from Products

    Window 2

    Begin tran

    Update Products

    Waitfor delay 10 seconds

    Select from Person.Persons

    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, 2012 at 2:54 am

    #1462557

  • RE: Task was forced to yield

    You've got a CLR proc that's heavy on CPU usage and does not have any sleeps or other voluntary yields in it. So after it has spend some time 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

    March 22, 2012 at 2:07 am

    #1462541

  • RE: SQL Server ignoring maximum file size on transaction log

    Brian Brown-204626 (3/21/2012)

    Am I correct that the restricted file growth option sets the maximum file size for the transaction log? If so, why would SQL Server be ignoring this...

    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 21, 2012 at 2:57 pm

    #1462441

  • RE: sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

    Snargables (3/21/2012)

    I was always under the impression that it’s best to break each possible combo or as close to every combo of input params into their own procs so u...

    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 21, 2012 at 2:54 pm

    #1462436

  • RE: sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

    All dynamic and ad-hoc SQL statements have their plans cached. The rules for caching plans is the same for procedures and for ad-hoc or dynamic SQL.

    The difference is 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 21, 2012 at 2:51 pm

    #1462433

Viewing 15 posts - 19,636 through 19,650 (of 49,552 total)