Make Slow Queries Fast
Execute Queries That Run in MillisecondsBy Gregory Whitlock
Length7h 43m
About this audiobook
SQL Server performance tuning and optimize slow queries. Are you tired of waiting for SQL Server queries to finish? Do you need to optimize SQL Server performance and tune slow queries for real-world workloads? This hands-on guide by Gregory Whitlock shows you exactly how to make slow queries fast, covering execution plans, indexing strategy, statistics, and query rewrites that cut runtimes dramatically. Whether you're a beginner or a pro, you'll learn practical techniques to speed up your database immediately.
Unlike Practical SQL, 2nd Edition by Anthony DeBarros or SQL QuickStart Guide by ClydeBank Technology, this book focuses exclusively on SQL Server and real workload tuning. You'll dive deep into execution plan analysis, learn to choose the right indexes, and master statistics updates that transform query performance. Each chapter includes real-world examples and before/after scenarios that show you exactly how to reduce runtime by 50% or more.
Inside, you'll discover:
How to read and interpret SQL Server execution plans to find bottlenecks
Indexing strategies that work for OLTP and data warehouse workloads
When and how to update statistics for optimal query plans
Query rewrites that eliminate unnecessary joins, subqueries, and scans
Techniques to avoid common pitfalls like parameter sniffing and missing indexes
This is not a theoretical book. It's a practical, hands-on guide for developers, DBAs, and data analysts who need immediate results. You'll learn to identify the root cause of slow queries, apply targeted fixes, and measure the improvement. By the end, you'll have a repeatable process for tuning any SQL Server query.
If you're ready to stop waiting and start optimizing, this book is your roadmap. Make Slow Queries Fast is the only guide you need to turn sluggish databases into high-performance engines.
Audiobook details
GenreTechnology
Length7 hrs 43 mins
Narrated byListen with 1,000+ voices
FormateBook with Audio
LanguageEnglish
Table of contents
1Introduction
2Preface
3Chapter 1 — The Performance Mindset: Why Databases Slow Down
4Chapter 2 — Measuring What Matters: Baselines and Wait Statistics
5Chapter 3 — Execution Plans: Your Query’s X-Ray
Show all chaptersShow less
6Chapter 4 — Indexing Strategy: From Missing to Covering
7Chapter 5 — Statistics: The Optimizer’s Compass
8Chapter 6 — Query Rewriting: Sargability and Set-Based Thinking
9Chapter 7 — Join and Subquery Optimization
10Chapter 8 — Caching and the Buffer Pool
11Chapter 9 — Locking, Blocking, and Concurrency
12Chapter 10 — Parallelism: Friend or Foe?
13Chapter 11 — Parameter Sniffing and Plan Caching
14Chapter 12 — TempDB Performance
15Chapter 13 — Hints and Trace Flags: When and How to Use Them
16Chapter 14 — Monitoring and Proactive Tuning
17Chapter 15 — Index and Statistics Maintenance Automation
18Chapter 16 — Advanced Topics: In-Memory OLTP and Columnstore
19Chapter 17 — Performance Testing and Regression Prevention
20Chapter 18 — The ShopFast Turnaround: Final Performance Summary
21About the Author
More from Gregory Whitlock
The Collected WorksNikola Tesla50h 9m$1 · $0.00
Never Lost AgainBill Kilday10h 1m$29 · $0.00
How the Internet HappenedBrian McCullough13h 28m$23 · $0.00
Collected Writings of Nikola TeslaNikola Tesla, Thomas Commerford Martin21h 50m$1 · $0.00
Just AspireAjai Chowdhry9h 13m$29 · $0.00
The Little Book of AliensAdam Frank8h 20m$26 · $0.00
The inventions, researches and writings of Nikola Tesla (Annotated)Thomas Commerford Martin16h 59m$2 · $0.00
KargilV.P. Malik15h 18m$24 · $0.00
Fire on the HorizonTom Shroder, John Konrad8h 23m$26 · $0.00
The Smell of Kerosene (Annotated)National Aeronautics and Space Administration, Donald L. Mallick, Peter W. Merlin11h 32m$2 · $0.00
The Boy Who Harnessed the WindWilliam Kamkwamba, Bryan Mealer10h 5m$29 · $0.00
Mars Rover CuriosityRob Manning, William L. Simon7h 43m$20
Across the Airless WildsEarl Swift10h 8m$29 · $0.00
Console WarsBlake J. Harris20h 41m$46 · $0.00
Improvised Munitions HandbookU.S. Department of Defense4h 38m$2 · $0.00
Escaping GravityLori Garver10h 54m$20 · $0.00
Wireless WarsJonathan Pelson8h 2m$20 · $0.00
The Forest UndergroundTony Rinaudo6h 22m$17
Atoms and AshesSerhii Plokhy12h 8m$23
Let There Be WaterSeth M. Siegel8h 36m$20 · $0.00
You may also like
An examination of some methods employed in determining the atomic weight of CadmiumJohn Emery Bucher59m$2 · $0.00
Ancient Egyptian and Greek LoomsH. Ling Roth1h 38m$1 · $0.00
The Source and Mode of Solar Energy Throughout the UniverseIsaac W. Heysinger10h 11m$1 · $0.00
Shafting, Pulleys, Belting and Rope TransmissionHubert E. Collins3h 15m$1 · $0.00
Value A CoinRichard W. Avery1h 31m$2.30
The Criticism of the New TestamentFrederick Henry Ambrose Scrivener35h 33m$2 · $0.00
The Higgs BosonScientific American12h 51m$23
Experiments on the Absence of Mechanical Connexion between Ether and MatterOliver Joseph Lodge1h 34m$1 · $0.00
Photographic Reproduction ProcessesPeter C. Duchochois3h 56m$2 · $0.00
Early Printed BooksE. Gordon Duff5h 55m$2.30
Ultimate PhysicsScientific American7h 5m$17
Experiments and Observations Tending to Illustrate the Nature and Properties of ElectricityWilliam Sir Watson1h 1m$1 · $0.00
Where Do Balloons Go?Jamie Lee Curtis4m$4 · $0.00
The Rise and Progress of PalaeontologyThomas Henry Huxley35m$2 · $0.00
Studies in Spermatogenesis (Vol.1&2) (Annotated)N. M. Stevens3h 38m$2 · $0.00
The Solution of the Pyramid Problem; or, Pyramid DiscoveriesRobert Ballard2h 14m$2 · $0.00
Histology of the Blood, Normal and PathologicalPaul Ehrlich, Adolf Lazarus5h 59m$3 · $0.00
Gout, with a section on ocular disease in the goutyLlewellyn J. Llewellyn20h 5m$2 · $0.00
An Introductory Course of Quantitative Chemical AnalysisHenry Paul Talbot7h 3m$2 · $0.00
Information Please, Vol. 1Black Eye Entertainment7h 41m$20