| 所在主题： | |
| 文件名: eBOOK_SQLServerExecutionPlans_2Ed_G_Fritchey.pdf | |
| 资料下载链接地址: https://bbs.pinggu.org/a-1780193.html | |
| 附件大小: | |
|
SQL Server Execution Plans, Second Edition(By Grant Fritchey)
Editorial Review Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? An execution plan describes what's going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the various tables defined in the query, which indexes it used, if any, how it performed any aggregations or sorting, and much more. It also estimates the cost of all of these operations, in terms of the relative load placed on the system. Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy. Table of Contents Chapter 1: Execution Plan Basics Chapter 2: Graphical Execution Plans for Basic Queries Chapter 3: Text and XML Execution Plans for Basic Queries Chapter 4: Understanding More Complex Query Plans Chapter 5: Controlling Execution Plans with Hints Chapter 6: Cursor Operations Chapter 7: Special Datatypes and Execution Plans Chapter 8: Advanced Topics About the author Grant Fritchey is a SQL Server MVP with over 20 years' experience in IT, including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C#, and Java. Grant has authored books for Apress and Simple-Talk, and joined Redgate as a Product Evangelist in January 2011. Find Grant on Twitter @GFritchey or on his blog. Publisher: Redgate Books(Free PDF download) [hide][/hide] |
|
熟悉论坛请点击新手指南
|
|
| 下载说明 | |
|
1、论坛支持迅雷和网际快车等p2p多线程软件下载，请在上面选择下载通道单击右健下载即可。 2、论坛会定期自动批量更新下载地址,所以请不要浪费时间盗链论坛资源,盗链地址会很快失效。 3、本站为非盈利性质的学术交流网站,鼓励和保护原创作品，拒绝未经版权人许可的上传行为。本站如接到版权人发出的合格侵权通知，将积极的采取必要措施；同时，本站也将在技术手段和能力范围内，履行版权保护的注意义务。 (如有侵权，欢迎举报) |
|
京ICP备16021002号-2 京B2-20170662号
京公网安备 11010802022788号
论坛法律顾问：王进律师
知识产权保护声明
免责及隐私声明
