Pro SQL server internals. ([2016])

• Record Type: Book
• Further Information: Note: Dmitri Korotkevitch.
• Authors: Korotkevitch, Dmitri
• Contents: 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.
• Edition: Second edition
• Publisher Details: Place of publication not identified : Apress
• Publication Date: 2016
• Copyright Date: 2016
• Extent: 1 online resource (1 volume), illustrations
• Subjects: 005.74; Computer science; Database management; Client/server computing; Client/server computing; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 1484219643; 9781484219645
• Related ISBNs: 9781484219638
• Notes: Note: Online resource; title from cover (Safari, viewed March 1, 2017).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.