Pro SQL Server Internals

Pro SQL Server Internals

4.11 - 1251 ratings - Source



Pro SQL Server Internals explains how different SQL Server components work qunder the hoodq and how they communicate with each other. This is the practical 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. Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. Youa€™ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, 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. Pro SQL Server Internals does the following: Explains how to design efficient database schema, indexing, and transaction strategies. Shows how various database objects and technologies are implemented internally and when they should or should not be used. Demonstrates how SQL Server executes queries and works with data and transaction logs. What youa€™ll learn Design and develop efficient database solutions utilizing SQL Server as the database backend. Troubleshoot and address design, concurrency, and performance issues in systems. Choose the right database objects and technologies for the job. Improve system availability and manageability and reduce implementation costs with data partitioning. Design efficient Disaster Recovery and High-Availability strategies for systems. Improve 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. Who this book is for Pro SQL Server Internals 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. Table of Contents Part 1 a€“ Tables and Indexes a€c Chapter 1: Data storage internals a€c Chapter 2: Tables and Indexes a€“ Internal Structure and Access Methods a€c Chapter 3: Statistics a€c Chapter 4: Special Indexing and Storage Features a€c Chapter 5: Index fragmentation a€c Chapter 6: Designing and tuning the indexes Part 2: Other things that matter a€c Chapter 7: Constraints a€c Chapter 8: Triggers a€c Chapter 9: Views a€c Chapter 10: Functions a€c Chapter 11: XML a€c Chapter 12: Temporary Tables a€c Chapter 13: CLR a€c Chapter 14: CLR types a€c Chapter 15: Data partitioning a€c Chapter 16: System design considerations Part 3: Locking, Blocking and Concurrency a€c Chapter 17: Lock types a€c Chapter 18: Troubleshooting Blocking issues a€c Chapter 19: Deadlocks a€c Chapter 20: Lock Escalations a€c Chapter 21: Optimistic isolation levels a€c Chapter 22: Application locks a€c Chapter 23: Schema locks a€c Chapter 24: Designing transaction strategies Part 4: Query Life Cycle a€c Chapter 25: Query Optimization and Execution a€c Chapter 26: Plan Caching Part 5: Practical Troubleshooting a€c Chapter 27: System Troubleshooting a€c Chapter 28: Extended events Part 6: Inside the transaction log a€c Chapter 29: Transaction Log Internals a€c Chapter 30: Designing a Backup Strategy a€c Chapter 31: Designing a High Availability Strategy Part 7: In-Memory OLTP Engine a€c Chapter 32: Hekaton (In Memory OLTP Engine) Part 8: Columnstore Indexes a€c Chapter 33: In-Memory OLTP Programmability a€c Chapter 34: Introduction to Columnstore indexes a€c Chapter 35: Clustered Columnstore indexesYou need to factor in this behavior into the statistics maintenance strategy in your system if an automatic statistics update is not optimal in the case of large tables ... Index fragmentation hurts most during index scans, when SQL Server needs to read large amounts of data from the disk ... One ofthe reasons why you want to reduce external fragmentation is sequential ... Both index rebuild and reorganize introduce heavy transaction log activity, and generate a large number of log recordsanbsp;...


Title:Pro SQL Server Internals
Author: Dmitri Korotkevitch
Publisher:Apress - 2014-06-17
ISBN-13:

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.


Click button below to register and download Ebook
Privacy Policy | Contact | DMCA