• Title: Inside the SQL Server Query Optimizer
• Author(s) Benjamin Nevarez
• Publisher: Red gate books
• Paperback: 272 psges
• eBook: PDF and ePub
• Language: English
• ISBN-10: 1906434603
• ISBN-13: 978-1906434601
• Share This:  

Book Description

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to database developers and administrators alike.

A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book explains the core concepts behind how the SQL Server Query Optimizer works.

With this knowledge, you'll be able to write superior queries, provide the Query Optimizer with all the information it needs to produce efficient execution plans, and troubleshoot the cases when the Query Optimizer is not giving you the best plan possible.

With over 15 years of experience in the use of Relational Databases (including SQL Server since version 6.5), Benjamin has watched the SQL Server Relational Engine grow and evolve. His insight will leave you with an excellent foundation in the practicalities of the Query Optimizer, and everything you need to know to start tuning your queries to perfection.

• Benjamin Nevarez is a database professional based in Los Angeles, California. He has more than 15 years of experience with relational databases, and has been working with SQL Server since version 6.5. Benjamin has been the technical editor of the two latest books by Kalen Delaney, including "SQL Server 2008 Internals." He holds a Master's Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Community Summit. You can read Benjamin's blog at www.benjaminnevarez.com.

• Amazon

• Miscrosoft SQL Server
• Database, Data Warehouse and Data Management
• Data Management White Papers
• Microsoft Windows and .NET

• Inside the SQL Server Query Optimizer (Benjamin Nevarez)
• The Mirror Site (1) - PDF

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• SQL Server Execution Plans, 3rd Edition (Grant Fritchey)

  This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans, leads you right from the basics of capturing plans to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

• SQL Server Concurrency: Locking, Blocking and Row Versioning

  This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

• SQL Server Backup and Restore (Shawn McGehee)

  This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes.

• SQL Server Team-based Development

  How to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as "normal" development.

• Performance Tuning with SQL Server Dynamic Management Views

  This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.

• 45 Database Performance Tips for Developers (Phil Factor, et al)

  Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.

• SQL Server Integration Services (SSIS) Succinctly (Rui Machado)

  With this book, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.

• SQL Server Analysis Services Succinctly (Stacia Misner)

  You will learn how to implement a business intelligence solution through SQL Server Analysis Services. You'll start with developing a database, and learn which architecture is most appropriate for the database's end use.

• Fundamentals of SQL Server Replication (Sebastian Meine)

  This book provides the hands-on introduction you need to get started, and explores all of the technology's most important strengths and weaknesses.