Pro SQL Server Internals, Second Edition

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