Pro SQL Server Internals
Buch in deiner Nähe kaufen
Beschreibung
This second edition of Pro SQL Server Internals provides the detailed knowledge that database professionals need in order to advance and be successful in their careers. Readers gain deep understanding that frees them from checklist-based approaches and allows fluid and creative approaches to configuring databases to meet business needs, and to maintaining those systems over the long haul. Database administrators are able to act from a depth of knowledge and respond and adapt quickly to changing business needs. Developers are able to engineer highly-performing systems with appropriate hooks for troubleshooting and diagnosis of abnormal events. Readers are able to go beyond the manuals and create database applications able to handle the intense query workloads that characterize an age of Big Data, Cloud Computing, and the Internet.
Provides detailed knowledge of Query Store and other new features Includes revamped coverage of columnstore indexes Covers indexing and transaction strategies
Autor*in
Dmitri Korotkevitch
Themen in »Pro SQL Server Internals«
SQL Server Internals Hekaton Columnstore Columnstore Indexes OLTP In-Memory Data storage Deadlocks Transactions Blocking Query Optimization Extended Events