High Performance SQL Server: The Go Faster Book

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 ...