{"product_id":"sql-server-execution-plans-third-edition-paperback","title":"SQL Server Execution Plans: Third Edition - Paperback","description":"\u003cp\u003eby \u003cb\u003eGrant Fritchey\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIf a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.\u003cbr\u003e \u003c\/p\u003e\u003cp\u003eI wrote this book with the singular goal of teaching you how to read SQL Server Execution plans\u003cbr\u003e \u003c\/p\u003e\u003cp\u003eIt will explain, among many other things, the following: \u003cbr\u003e \u003c\/p\u003e \u003cul\u003e \u003cli\u003eHow to capture execution plans using manual and automatic methods\u003c\/li\u003e \u003cli\u003eA documented method for reading and interpreting execution plans\u003c\/li\u003e \u003cli\u003eHow common SQL Server objects, such as indexes, views, stored procedures, and so on, appear in execution plans\u003c\/li\u003e \u003cli\u003eHow to control execution plans with hints and plan guides, and why this is a double-edged sword\u003c\/li\u003e \u003cli\u003eHow the Query Store works with, and collects data on, execution plans\u003cbr\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWith this knowledge, you'll have everything you need to read the execution plan, for any query of your own, regardless of complexity, and understand what it does and what is causing the bad performance. It is still your job to work out how best to fix it, but your new understanding of execution plans will give a much better chance of success \u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 520\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.05 x 9.25 x 7.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e October 01, 2018\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42742207545407,"sku":"9781910035245","price":41.45,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/8a394a89355d29ae69e0a3f03f568deb.webp?v=1765163036","url":"https:\/\/dhlswag.com\/products\/sql-server-execution-plans-third-edition-paperback","provider":"BBB","version":"1.0","type":"link"}