紀錄類型: |
書目-電子資源
: Monograph/item
|
正題名/作者: |
Pro SQL server internals/ by Dmitri Korotkevitch. |
作者: |
Korotkevitch, Dmitri. |
出版者: |
Berkeley, CA :Apress : : 2016., |
面頁冊數: |
xxxi, 804 p. :ill., digital ;24 cm. |
內容註: |
Part 1: Tables and Indexes -- 1. Data Storage Internals -- 2. Tables and Indexes -- 3. Statistics -- 4. Special Indexing and Storage Features -- 5. SQL Server 2016 Enhancements -- 6. Index Fragmentation -- 7. Designing and Tuning the Indexes -- Part 2: Other Things That Matter -- 8. Constraints -- 9. Triggers -- 10. Views -- 11. Functions -- 12. XML and JSON -- 13. Temporary Tables and TempDB -- 14. CLR -- 15. CLR Types -- 16. Data Partitioning -- Part 3: Locking, Blocking and Concurrency -- 17. Lock Types and Transaction Isolation Levels -- 18. Troubleshooting Blocking Issues -- 19. Deadlocks -- 20. Lock Escalations -- 21. Optimistic Isolation Levels -- 22. Application Locks -- 23. Schema Locks -- 24. Designing Transaction Strategies -- Part 4: Query Life Cycle -- 25. Query Optimization and Execution -- 26. Plan Caching -- Part 5: Practical Troubleshooting -- 27. System Troubleshooting -- 28. Extended events -- 29. Query Store -- Part 6: Inside the Transaction Log -- 30. Transaction Log Internals -- 31. Backup and Restore -- 32. High Availability Technologies -- Part 7: In-Memory OLTP Engine -- 33. Column-Based Storage and Batch Mode Execution -- 34. Columnstore Indexes -- Part 8: In-Memory OLTP Engine -- 35. In-Memory OLTP Internals -- 36. Transaction Processing in In-Memory OLTP -- 37. In-Memory OLTP Programmability. |
Contained By: |
Springer eBooks |
標題: |
Computer Science. - |
電子資源: |
http://dx.doi.org/10.1007/978-1-4842-1964-5 |
ISBN: |
9781484219645 |