Pro SQL Server Internals
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. Youall 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 youall 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 ac Chapter 1: Data storage internals ac Chapter 2: Tables and Indexes a Internal Structure and Access Methods ac Chapter 3: Statistics ac Chapter 4: Special Indexing and Storage Features ac Chapter 5: Index fragmentation ac Chapter 6: Designing and tuning the indexes Part 2: Other things that matter ac Chapter 7: Constraints ac Chapter 8: Triggers ac Chapter 9: Views ac Chapter 10: Functions ac Chapter 11: XML ac Chapter 12: Temporary Tables ac Chapter 13: CLR ac Chapter 14: CLR types ac Chapter 15: Data partitioning ac Chapter 16: System design considerations Part 3: Locking, Blocking and Concurrency ac Chapter 17: Lock types ac Chapter 18: Troubleshooting Blocking issues ac Chapter 19: Deadlocks ac Chapter 20: Lock Escalations ac Chapter 21: Optimistic isolation levels ac Chapter 22: Application locks ac Chapter 23: Schema locks ac Chapter 24: Designing transaction strategies Part 4: Query Life Cycle ac Chapter 25: Query Optimization and Execution ac Chapter 26: Plan Caching Part 5: Practical Troubleshooting ac Chapter 27: System Troubleshooting ac Chapter 28: Extended events Part 6: Inside the transaction log ac Chapter 29: Transaction Log Internals ac Chapter 30: Designing a Backup Strategy ac Chapter 31: Designing a High Availability Strategy Part 7: In-Memory OLTP Engine ac Chapter 32: Hekaton (In Memory OLTP Engine) Part 8: Columnstore Indexes ac Chapter 33: In-Memory OLTP Programmability ac Chapter 34: Introduction to Columnstore indexes ac 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 |
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.
