Forum Replies Created

Viewing 15 posts - 286 through 300 (of 49,552 total)

  • RE: Is this Deadlock due to Lock Partitions?

    Ah, I see what's happening.

    There's a SELECT earlier in the (implicitly started) transaction that's taking a table-level shared lock. You're going to have to identify what that select...

    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, 2018 at 9:41 am

    #1981854

  • RE: Query Taking more time to Run

    https://www.red-gate.com/simple-talk/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/

    Specifically the second section

    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, 2018 at 9:08 am

    #1981852

  • RE: updates are not happening through ssms

    dastagiri16 - Saturday, March 3, 2018 8:43 AM

    is trigger  blocking my table updation from gui .is it expected behavior of triggers...

    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, 2018 at 9:05 am

    #1981851

  • RE: How to bring database just before the delete occurred.

    coolchaitu - Saturday, March 3, 2018 6:52 AM

    GilaMonster - Saturday, March 3, 2018 6:30 AM

    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, 2018 at 9:00 am

    #1981850

  • RE: How to bring database just before the delete occurred.

    Restore the last full backup before the data was deleted WITH NORECOVERY, then restore the last differential backup WITH NORECOVERY, then restore all log backups after that point 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

    March 3, 2018 at 6:30 am

    #1981839

  • RE: Is this Deadlock due to Lock Partitions?

    What are the settings for Allow_row_locks and Allow_Page_locks for that table?
    An update of 3 rows, filtered by the clustered index should not be taking table locks.

    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, 2018 at 5:58 am

    #1981837

  • RE: Help me in designing table and its indexes

    https://www.sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    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, 2018 at 5:55 am

    #1981836

  • RE: Verify backup files. How much does it help?

    Unless you take your backup WITH CHECKSUM, the verify just reads the header. It's pretty worthless.

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

    #1981746

  • RE: How does SQL Server handle concurrent operations?

    junk.mail291276 - Thursday, March 1, 2018 4:01 PM

    When you say "If you disable both page and row locks, you're forcing SQL 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

    March 2, 2018 at 2:43 am

    #1981745

  • RE: How does SQL Server handle concurrent operations?

    Don't fiddle with your lock escalation or page/row lock settings unless you know EXACTLY what you're doing and why. You can cause some serious problems messing with those.

    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 1, 2018 at 2:05 pm

    #1981708

  • RE: How does SQL Server handle concurrent operations?

    I gave you a couple of suggestions.

    GilaMonster - Wednesday, February 28, 2018 12:03 PM

    500 is a generic error, usually displayed...

    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 1, 2018 at 11:02 am

    #1981683

  • RE: How does SQL Server handle concurrent operations?

    Locking happens on a row, page or table basis, always within a single database. Blocking does not happen at the server or database level (unless you're doing server reconfigurations or...

    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

    February 28, 2018 at 3:15 pm

    #1981566

  • RE: Transaction logs

    Not unless you want to break the log chain, compromise the DB's recoverability in the case of a disaster.

    Restarting the log backups would have cleared the log, allowing...

    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

    February 28, 2018 at 12:47 pm

    #1981540

  • RE: How does SQL Server handle concurrent operations?

    junk.mail291276 - Tuesday, February 27, 2018 4:52 PM

    We are wondering if maybe our database is configured to handle only one operation 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

    February 28, 2018 at 12:03 pm

    #1981527

  • RE: how can I configure what will be registered nside the log file?

    The only thing you can configure there is the DB's recovery model, which affects how long log records are retained, and whether some operations will be minimally or fully logged.

    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

    February 28, 2018 at 12:00 pm

    #1981526

Viewing 15 posts - 286 through 300 (of 49,552 total)