Inside the SQL Server Query Optimizer

Inside the SQL Server Query Optimizer, 9781906434601 (1906434603), Red gate, 2011

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.

Comments

Amazing Books

CliffsNotes Making Microsoft Windows Me Work For You

Cliffs Notes, 2000

What you need to know now When it comes to pinpointing the stuff you really need to know, nobody does it better than CliffsNotes. Packed with time-saving tips, tricks, and techniques, this no-nonsense guide delivers the practical know-how you need to get up and running fast on Windows Me. CliffsNotes. They helped you get through school. Now let...

Mining the Social Web: Analyzing Data from Facebook, Twitter, LinkedIn, and Other Social Media Sites

O'Reilly, 2011

Facebook, Twitter, and LinkedIn generate a tremendous amount of valuable social data, but how can you find out who's making connections with social media, what they’re talking about, or where they’re located? This concise and practical book shows you how to answer these questions and more. You'll learn how to...

From Concept to Wall Street: A Complete Guide to Entrepreneurship and Venture Capital

Prentice Hall, 2002

From Concept to Wall Street is the definitive guide to the new realities of venture capital. Two leading experts in venture-backed entrepreneurship offer start-to-finish coverage of the entire process: planning, teambuilding, protecting intellectual property, identifying and negotiating funding, and managing to...

Computer Telephony Demystified

McGraw-Hill, 2000

Reshape your world with computer telephony

There’s no stopping the computer telephony (CT) revolution. Everywhere you look, CT is replacing the existing telephony infrastructure with products, systems, and solutions based on off-the-shelf computer technology.

If you’re ready to take advantage of customizable telephony...

Principles of Spread-Spectrum Communication Systems

Springer, 2004

The goal of this book is to provide a concise but lucid explanation and derivation
of the fundamentals of spread-spectrum communication systems. Although
spread-spectrum communication is a staple topic in textbooks on digital communication,
its treatment is usually cursory, and the subject warrants a more
intensive exposition....

Thermal Transport for Applications in Micro/Nanomachining (Microtechnology and MEMS)

Springer, 2008

Nanotechnology remains one of the most active and intriguing research and development areas. While the importance of novel devices and systems engineered at the nanoscale is steadily increasing, the success of future nanoscale applications will depend on the effective implementation of nanomachining and nanomanufacturing platforms. This book...