Inside the SQL Server Query OptimizerКНИГИ » ОС И БД
Название: Inside the SQL Server Query Optimizer Автор: Benjamin Nevarez Издательство: Simple Talk Publishing Год: 2010 Формат: PDF Страниц: 252 Размер: 11,46 МБ Язык: English
This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. 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 DBAs and Developers 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 Query Optimizer 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.
Microsoft SQL Server 2017 on Linux Название: Microsoft SQL Server 2017 on Linux Автор: Benjamin Nevarez Издательство: McGraw-Hill Education Год: 2018 Формат: epub Страниц: 304 Размер:...
SQL Server Execution Plans, Third Edition Название: SQL Server Execution Plans, Third Edition Автор: Grant Fritchey Издательство: Red Gate Books ISBN: 1910035246 Год: 2018 Страниц: 515 ...
Pro SQL Server Wait Statistics Название: Pro SQL Server Wait Statistics Автор: Enrico van de Laar Издательство: Apress ISBN: 1484211405 Год: 2015 Страниц: 336 Язык: английский...
High Performance SQL Server: The Go Faster Book Название: High Performance SQL Server: The Go Faster Book Автор: Benjamin Nevarez Издательство: Apress Год: 2016 Страниц: 288 Формат: PDF Размер: 11...
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Навигация
Вход на сайт
Реклама
Inside the SQL Server Query Optimizer 
