{"product_id":"9781430259633","title":"Pro SQL Server Internals","description":"\u003cp\u003e\u003cem\u003ePro SQL Server Internals\u003c\/em\u003e explains how different SQL Server components work \"under the hood\" and how they communicate with each other. This is \u003cem\u003ethe \u003c\/em\u003epractical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.\u003c\/p\u003e\u003cp\u003e\u003cem\u003ePro SQL Server Internals\u003c\/em\u003e covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With \u003cem\u003ePro SQL Server Internals\u003c\/em\u003e, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.\u003c\/p\u003e\u003cp\u003e\u003cem\u003ePro SQL Server Internals\u003c\/em\u003e does the following:\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eExplains how to design efficient database schema, indexing, and transaction strategies.\u003c\/li\u003e\n\u003cli\u003eShows how various database objects and technologies are implemented internally and when they should or should not be used.\u003c\/li\u003e\n\u003cli\u003eDemonstrates how SQL Server executes queries and works with data and transaction logs.\u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e\n\u003cli\u003eDesign and develop efficient database solutions utilizing SQL Server as the database backend.\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and address design, concurrency, and performance issues in systems.\u003c\/li\u003e\n\u003cli\u003eChoose the right database objects and technologies for the job.\u003c\/li\u003e\n\u003cli\u003eImprove system availability and manageability and reduce implementation costs with data partitioning.\u003c\/li\u003e\n\u003cli\u003eDesign efficient Disaster Recovery and High-Availability strategies for systems.\u003c\/li\u003e\n\u003cli\u003eImprove the performance of OLTP and Data Warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine and Clustered Columnstore Indexes.\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003e\u003c\/em\u003e\u003cem\u003ePro SQL Server Internals\u003c\/em\u003e is a book for developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem, rather than applying a 'band aid' to it.\u003c\/p\u003e\u003cp\u003e      \u003c\/p\u003e     Table of Contents\u003cp\u003ePart 1 – Tables and Indexes\u003c\/p\u003e\u003cp\u003e• Chapter 1: Data storage internals\u003c\/p\u003e\u003cp\u003e• Chapter 2: Tables and Indexes – Internal Structure and Access Methods\u003c\/p\u003e\u003cp\u003e• Chapter 3: Statistics \u003c\/p\u003e\u003cp\u003e• Chapter 4: Special Indexing and Storage Features\u003c\/p\u003e\u003cp\u003e• Chapter 5: Index fragmentation\u003c\/p\u003e\u003cp\u003e• Chapter 6: Designing and tuning the indexes \u003c\/p\u003e\u003cp\u003ePart 2: Other things that matter\u003c\/p\u003e\u003cp\u003e• Chapter 7: Constraints\u003c\/p\u003e\u003cp\u003e• Chapter 8: Triggers\u003c\/p\u003e\u003cp\u003e• Chapter 9: Views \u003c\/p\u003e\u003cp\u003e• Chapter 10: Functions \u003c\/p\u003e\u003cp\u003e• Chapter 11: XML \u003c\/p\u003e\u003cp\u003e• Chapter 12: Temporary Tables \u003c\/p\u003e\u003cp\u003e• Chapter 13: CLR\u003c\/p\u003e\u003cp\u003e• Chapter 14: CLR types \u003c\/p\u003e\u003cp\u003e• Chapter 15: Data partitioning \u003c\/p\u003e\u003cp\u003e• Chapter 16: System design considerations \u003c\/p\u003e\u003cp\u003ePart 3: Locking, Blocking and Concurrency\u003c\/p\u003e\u003cp\u003e• Chapter 17: Lock types \u003c\/p\u003e\u003cp\u003e• Chapter 18: Troubleshooting Blocking issues\u003c\/p\u003e\u003cp\u003e• Chapter 19: Deadlocks \u003c\/p\u003e\u003cp\u003e• Chapter 20: Lock Escalations \u003c\/p\u003e\u003cp\u003e• Chapter 21: Optimistic isolation levels \u003c\/p\u003e\u003cp\u003e• Chapter 22: Application locks \u003c\/p\u003e\u003cp\u003e• Chapter 23: Schema locks \u003c\/p\u003e\u003cp\u003e• Chapter 24: Designing transaction strategies \u003c\/p\u003e\u003cp\u003ePart 4: Query Life Cycle \u003c\/p\u003e\u003cp\u003e• Chapter 25: Query Optimization and Execution\u003c\/p\u003e\u003cp\u003e• Chapter 26: Plan Caching\u003c\/p\u003e\u003cp\u003ePart 5: Practical Troubleshooting \u003c\/p\u003e\u003cp\u003e• Chapter 27: System Troubleshooting\u003c\/p\u003e\u003cp\u003e• Chapter 28: Extended events\u003c\/p\u003e\u003cp\u003ePart 6: Inside the transaction log \u003c\/p\u003e\u003cp\u003e• Chapter 29: Transaction Log Internals \u003c\/p\u003e\u003cp\u003e• Chapter 30: Designing a Backup Strategy \u003c\/p\u003e\u003cp\u003e• Chapter 31: Designing a High Availability Strategy \u003c\/p\u003e\u003cp\u003ePart 7: In-Memory OLTP Engine\u003c\/p\u003e\u003cp\u003e• Chapter 32: Hekaton (In Memory OLTP Engine)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003ePart 8: Columnstore Indexes\u003c\/p\u003e\u003cp\u003e• Chapter 33: In-Memory OLTP Programmability\u003c\/p\u003e\u003cp\u003e• Chapter 34: Introduction to Columnstore indexes \u003c\/p\u003e\u003cp\u003e• Chapter 35: Clustered Columnstore indexes \u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47122745065712,"sku":"9781430259633","price":47.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430259633_p0.jpg?v=1763749405","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430259633","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}