O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

A

  1. ACCESS_METHODS_DATASET_PARENT latch type

  2. ACCESS_METHODS_HOBT_COUNT latch type

  3. ACCESS_METHODS_HOBT_VIRTUAL_ROOT latch type

  4. ACCESS_METHODS_SCAN_KEY_GENERATOR latch type

  5. ACCESS_METHODS_SCAN_RANGE_GENERATOR latch type

  6. ACID transaction characteristics

  7. Actions in Extended Events

  8. Active node

  9. ACTIVE_TRANSACTION log_reuse_wait_desc value

  10. Actual number of rows in the execution plan, 58

  11. Ad-hoc queries

  12. Adjacency list in hierarchies

  13. AFTER Triggers

  14. Aligned indexes

  15. Allocation map pages

  16. Allocation unit on disk

  17. Allocation units

  18. ALTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION command

  19. ALTER DATABASE SET PARTNER TIMEOUT command

  20. ALTER DATABASE SET QUERY_STORE command

  21. ALTER DATABASE SET QUERY_STORE CLEAR command

  22. ALTER DATABASE SET READ_COMMITTED_SNAPSHOT command

  23. ALTER INDEX REBUILD

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required