作者：Grant Fritchey, Sajal Dam
出版日期：March 16, 2009
出版社：Apress
页数：600
ISBN：ISBN-10: 1430219025 ISBN-13: 978-1430219026
文件格式：PDF


Product Description
SQL Server 2008 Query Performance Tuning Distilled presents adirect trouble–shooting methodology for identifying poorly performingstored procedures and queries, isolating the causes of that poorperformance, and fixing the underlying problems. Each chapter isdedicated to one of the top causes of poorly performing queries andshows methods for identifying and dealing with the problems in thatchapter’s domain. Emphasis is always put upon or placed upon practicalmethods that you can put to immediate use in your day–to–day work. SQLServer 2008 functionality, tips, and tricks are emphasized in eachsubject area.Emphasizes the practical. Does not bury readers in theory.Gives readers practical techniques to immediately apply in their daily work.Dedicates a chapter to each of the most common, performance–related problem areas.What you’ll learnIdentify and fix poorly performing queries that are hurting your business.Read query execution plans and identify bottlenecks in performance.Record system performance metrics for trend analysis.Learn to design databases and write Transact–SQL code to avoid common problems.Understand what an index is, what it does, and how to build one.Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance.Who is this book forSQL Server Query Performance Tuning Distilled is aimed atanyone writing business–critical Transact–SQL queries, and also atthose responsible for the continued good performance of those queries.Developers, database administrators, business intelligence analysts,and any others who develop Transact–SQL queries will find this book anindispensible resource for getting the most out of what SQL Server 2008has to offer.
About the Author
Grant Fritchey is currently working as a development DBA for FM Global,an industry–leading engineering and insurance company. In his previoustime as a DBA and developer, he has worked at three failed dot–coms, amajor consulting company, and a global bank. He has developedlarge–scale applications in languages such as VB, C#, and Java and haslived with SQL Server from the hoary days of 6.0, right through to2008. His nickname at work is “The Scary DBA.” He even has an officialname plate, and he displays it proudly.
Grant volunteers for the Professional Association of SQL ServerUsers (PASS) and has written and published articles on various topicsrelating to SQL Server at Simple–Talk, SQL Server Central, SQL ServerPerformance, the PASS web site, SQL Standard, and the SQL ServerWorldwide Users Group. He is the author of the book Dissecting SQL Server Execution Plans. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG).
Outside work, Grant kayaks, learns and teaches self–defense, brewshis own beer, chops wood to heat his house, raises his kids, and helpslead a pack of Cub Scouts.
Sajal Dam holds a master’s of technology degree in computer sciencefrom the Indian Institute of Science, Bangalore, and has been workingwith Microsoft technologies for over 12 years. He has developed anextensive background in designing database applications and managingsoftware development. Sajal also possesses significant experience introubleshooting and optimizing the performance of Microsoft-basedapplications, from front-end web pages to back-end databases.
While working at Microsoft Corporation, Sajal helped many Fortune500 companies design scalable database solutions and maximize theperformance of their database environments. Currently as an ITstrategist at Dell, Sajal manages Dell’s vast database infrastructureby optimizing not only the databases, but also the database managementprocesses, tools, and use of best practices. He also works closely withthe application development teams and vendors, including Microsoft, inanalyzing and resolving performance bottlenecks.