Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Optimize Microsoft SQL Server 2014 queries and applications<i>Microsoft SQL Server 2014 Query Tuning & Optimization</i> is filled with ready-to-use techniques for creating high-performance queries and applications. The book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You'll also get tips for troubleshooting underperforming queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, is fully covered in this practical guide.<br /><br /><br />Understand how the query optimizer works<br />Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools<br />Work with query operators for da
0コメント