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
Mostrar todos os capítulosVer menos
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
LiftoffEric Berger9h 4m4.6 (9.5K)$29 · $0.00
The Honey BusMeredith May9h 31m4.4 (16.6K)$25 · $0.00
Collected Writings of Nikola TeslaThomas Commerford Martin, Nikola Tesla19h 42m4.4 (2.8K)$1.99 · $0.00
Operation PedestalMax Hastings12h 29m4.4 (5.2K)$29 · $0.00
When the Heavens Went on SaleAshlee Vance18h 20m4.4 (3K)$40 · $0.00
Everybody Has a Podcast (Except You)Justin McElroy, Travis McElroy, Griffin McElroy5h 9m4.3 (2.3K)$24 · $0.00
Hands of TimeRebecca Struthers8h 8m4.4 (1.3K)$26 · $0.00
Never Lost AgainBill Kilday10h 1m4.4 (805)$29 · $0.00
How the Internet HappenedBrian McCullough13h 28m4.3 (2.7K)$23 · $0.00
Collected Writings of Nikola TeslaNikola Tesla, Thomas Commerford Martin21h 50m4.3 (1.7K)$1 · $0.00
Just AspireAjai Chowdhry9h 13m4.4 (260)$29 · $0.00
The Little Book of AliensAdam Frank8h 20m4.3 (1.3K)$26 · $0.00
The inventions, researches and writings of Nikola Tesla (Annotated)Thomas Commerford Martin16h 59m4.3 (1.3K)$2 · $0.00
KargilV.P. Malik15h 18m4.3 (2K)$24 · $0.00
Experiments with Alternating CurrentsNikola Tesla9h 16m4.3 (874)$1.99 · $0.00
Fire on the HorizonTom Shroder, John Konrad8h 23m4.3 (858)$26 · $0.00
The Smell of Kerosene (Annotated)National Aeronautics and Space Administration, Donald L. Mallick, Peter W. Merlin11h 32m4.3 (523)$2 · $0.00
The Boy Who Harnessed the WindWilliam Kamkwamba, Bryan Mealer10h 5m4.2 (78.9K)$29 · $0.00
Across the Airless WildsEarl Swift10h 8m4.3 (1.3K)$29 · $0.00
Console WarsBlake J. Harris20h 41m4.2 (13.7K)$46 · $0.00
You may also like
Where Do Balloons Go?Jamie Lee Curtis4m4.0 (1.2K)$4 · $0.00
Neutrino HuntersRay Jayawardhana6h 4m4.1 (955)$17
Pete the Cat Plays Hide-and-SeekJames Dean, Kimberly Dean6m4.3 (572)$4 · $0.00
Become a Power BI Data AnalystVictor Espinoza6h 51m$5 · $0.00
How to Make Money Flipping Fishing Gear - How to Evaluate Rods, Reels, and Accessories, Build Complete Kits, and Resell for ProfitJACK FLIPWELL6h 41m$7.80 · $0.00
How to Make Money Flipping Motorhomes and Travel Trailers - How to Assess Structure and Systems, Plan Profitable Renovations, and Resell SafelyJACK FLIPWELL2h 2m$7.70 · $0.00
AP Macroeconomics Exam Study GuideMarie Peterson9h 52m$10
The Source and Mode of Solar Energy Throughout the UniverseIsaac W. Heysinger10h 11m$1 · $0.00
Early Printed BooksE. Gordon Duff5h 55m3.7 (18)$2.30
Experiments and Observations Tending to Illustrate the Nature and Properties of ElectricityWilliam Sir Watson1h 1m$1 · $0.00
Structural Civil PE Exam Questions AnsweredGordon Fairweather14h 8m4.8 (10)$80
The Every-Machine Bread Maker CookbookCerys J. Chamberlain11h 10m$11.50
Experiments on the Absence of Mechanical Connexion between Ether and MatterOliver Joseph Lodge1h 34m$1 · $0.00
Aestheticism in ArtWilliam Hogarth4h 43m$18 · $0.00
Vermeer and His TimePhilip L. Hale3h 11m$18 · $0.00
Popular Astronomy: A Series of Lectures Delivered at IpswichGeorge Biddell Airy8h 53m$2 · $0.00
Power BI for Business IntelligenceLena Farrell7h 24m$5 · $0.00
Fossil ButterfliesSamuel Hubbard Scudder3h 18m$2 · $0.00
Old Glass and How to Collect itJ. Sydney Lewis2h 55m$1.50 · $0.00
Behind the ScreenSamuel Goldwyn7h 12m$1 · $0.00