|
Books > Computing & IT > Computer software packages > Database software
|
Buy Now
SQL Server 2022 Query Performance Tuning - Troubleshoot and Optimize Query Performance (Paperback, 6th ed.)
Loot Price: R1,390
Discovery Miles 13 900
You Save: R272
(16%)
|
|
|
SQL Server 2022 Query Performance Tuning - Troubleshoot and Optimize Query Performance (Paperback, 6th ed.)
Expected to ship within 18 - 22 working days
|
Troubleshoot slow-performing queries and make them run faster.
Database administrators and SQL developers are constantly under
pressure to provide more speed. This new edition has been
redesigned and rewritten from scratch based on the last 15 years of
learning, knowledge, and experience accumulated by the author. The
book Includes expanded information on using extended events,
automatic execution plan correction, and other advanced features
now available in SQL Server. These modern features are covered
while still providing the necessary fundamentals to better
understand how statistics and indexes affect query performance. The
book gives you knowledge and tools to help you identify poorly
performing queries and understand the possible causes of that poor
performance. The book also provides mechanisms for resolving the
issues identified, whether on-premises, in containers, or on cloud
platform providers. You'll learn about key fundamentals, such as
statistics, data distribution, cardinality, and parameter sniffing.
You'll learn to analyze and design your indexes and your queries
using best practices that ward off performance problems before they
occur. You'll also learn to use important modern features, such as
Query Store to manage and control execution plans, the automated
performance tuning feature set, and memory-optimized OLTP tables
and procedures. You will be able to troubleshoot in a systematic
way. Query tuning doesn't have to be difficult. This book helps you
to make it much easier. What You Will Learn Use Query Store to
understand and easily change query performance Recognize and
eliminate bottlenecks leading to slow performance Tune queries
whether on-premises, in containers, or on cloud platform providers
Implement best practices in T-SQL to minimize performance risk
Design in the performance that you need through careful query and
index design Understand how built-in, automatic tuning can assist
your performance enhancement efforts Protect query performance
during upgrades to the newer versions of SQL Server Who This Book
Is For Developers and database administrators with responsibility
for query performance in SQL Server environments, and anyone
responsible for writing or creating T-SQL queries and in need of
insight into bottlenecks (including how to identify them,
understand them, and eliminate them)
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
You might also like..
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
