Index

A

  1. ActiveX data objects for .NET

  2. ActualRowsRead attribute

  3. Allocation ring buffer

  4. ALTER EVENT SESSION

  5. ALTER INDEX REBUILD

  6. ALTER INDEX REORGANIZE

  7. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY statement

  8. ALTER TABLE ADD INDEX statement

  9. Application programming interfaces (API)

  10. AUTOGROW_ALL_FILES filegroup property

  11. Autogrow/autoshrink events

  12. Auto-growth

  13. Auto-parameterization

  14. avg_page_space

B

  1. Batches comparing

  2. 32-bit or 64-bit architecture

  3. Blocking

  4. Buffer cache

  5. Bulk changed map (BCM)

C

  1. Cache hit ratio

  2. Call-level interface (CLI)

  3. Cardinality estimation

  4. Checkpoint pages/sec

  5. CLEANUP_POLICY options

  6. Clustered columnstore index

  7. Clustered indexes

  8. cntr_value columns

  9. Columnstore index

  10. Common language runtime (CLR)

  11. Compression

  12. CONTAINS MEMORY_OPTIMIZED_DATA clause

  13. CREATE EVENT SESSION

  14. CX_PACKET ...

Get High Performance SQL Server: The Go Faster Book now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.