Login

Korotkevitch, Dmitri

Pro SQL Server Internals

Korotkevitch, Dmitri - Pro SQL Server Internals, ebook

72,25€

Ebook, PDF with Adobe DRM
ISBN: 9781484219645
DRM Restrictions

PrintingNot allowed
Copy to clipboardNot allowed

Table of contents

Part I. Tables and Indexes

1. Data Storage Internals
Dmitri Korotkevitch

2. Tables and Indexes: Internal Structure and Access Methods
Dmitri Korotkevitch

3. Statistics
Dmitri Korotkevitch

4. Special Indexing and Storage Features
Dmitri Korotkevitch

5. SQL Server 2016 Features
Dmitri Korotkevitch

6. Index Fragmentation
Dmitri Korotkevitch

7. Designing and Tuning the Indexes
Dmitri Korotkevitch

Part II. Other Things That Matter

8. Constraints
Dmitri Korotkevitch

9. Triggers
Dmitri Korotkevitch

10. Views
Dmitri Korotkevitch

11. User-Defined Functions
Dmitri Korotkevitch

12. XML and JSON
Dmitri Korotkevitch

13. Temporary Objects and TempDB
Dmitri Korotkevitch

14. CLR
Dmitri Korotkevitch

15. CLR Types
Dmitri Korotkevitch

16. Data Partitioning
Dmitri Korotkevitch

Part III. Locking, Blocking, and Concurrency

17. Lock Types and Transaction Isolation Levels
Dmitri Korotkevitch

18. Troubleshooting Blocking Issues
Dmitri Korotkevitch

19. Deadlocks
Dmitri Korotkevitch

20. Lock Escalation
Dmitri Korotkevitch

21. Optimistic Isolation Levels
Dmitri Korotkevitch

22. Application Locks
Dmitri Korotkevitch

23. Schema Locks
Dmitri Korotkevitch

24. Designing Transaction Strategies
Dmitri Korotkevitch

Part IV. Query Life Cycle

25. Query Optimization and Execution
Dmitri Korotkevitch

26. Plan Caching
Dmitri Korotkevitch

Part V. Practical Troubleshooting

27. Extended Events
Dmitri Korotkevitch

28. System Troubleshooting
Dmitri Korotkevitch

29. Query Store
Dmitri Korotkevitch

Part VI. Inside the Transaction Log

30. Transaction Log Internals
Dmitri Korotkevitch

31. Backup and Restore
Dmitri Korotkevitch

32. High Availability Technologies
Dmitri Korotkevitch

Part VII. Columnstore Indexes

33. Column-Based Storage and Batch Mode Execution
Dmitri Korotkevitch

34. Columnstore Indexes
Dmitri Korotkevitch

Part VIII. In-Memory OLTP Engine

35. In-Memory OLTP Internals
Dmitri Korotkevitch

36. Transaction Processing in In-Memory OLTP
Dmitri Korotkevitch

37. In-Memory OLTP Programmability
Dmitri Korotkevitch

Keywords: Computer Science, Database Management

Author(s)
Publisher
Springer
Publication year
2016
Language
en
Edition
2nd ed.
Page amount
31 pages
Category
Information Technology, Telecommunications
Format
Ebook
eISBN (PDF)
9781484219645
Printed ISBN
978-1-4842-1963-8

Similar titles