NOLOCK vs READPAST Lock Hints

Sdílet
Vložit
  • čas přidán 8. 08. 2023
  • Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. Five courses at a highly discounted price. sqlmaestros.com/all-in-one-bu...
    The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.
    If you are a fan of live classes, you can explore the SQL Server Performance Tuning Master Class. 40 hours of deep-dive LIVE training. Attend LIVE & get the class recordings for a lifetime. sqlmaestros.com/sql-server-wo...
  • Věda a technologie

Komentáře • 1

  • @blackisblack22
    @blackisblack22 Před 11 měsíci

    Readpast is definitely a bad idea except maybe if it were locking at cell level.