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
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 6m4.3 (874)$1 · $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
Improvised Munitions HandbookU.S. Department of Defense4h 49m4.3 (1.6K)$1.99 · $0.00
Escaping GravityLori Garver10h 54m4.2 (2.2K)$20 · $0.00
Wireless WarsJonathan Pelson8h 2m4.3 (418)$20 · $0.00
Let There Be WaterSeth M. Siegel8h 36m4.2 (2.3K)$20 · $0.00
You may also like
Where Do Balloons Go?Jamie Lee Curtis4m4.0 (1.2K)$4 · $0.00
How to Make Money Flipping Used Books - How to Identify Valuable Editions, Assess Condition, Build Profitable Lots, and Sell to the Right ReadersJACK FLIPWELL8h 19m$8.10 · $0.00
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
AP Macroeconomics Exam Study GuideMarie Peterson9h 52m$10
Mobile Hydraulic Fluid PowerRoy Vandermeer10h 53m$45
Structural Civil PE Exam Questions AnsweredGordon Fairweather14h 8m4.8 (10)$80
Shafting, Pulleys, Belting and Rope TransmissionHubert E. Collins3h 15m$1 · $0.00
The Changing Conceptions of the Universe - From Newton to Einstein -Benjamin Harrow, Albert Einstein, Arthur Stanley Eddington, Joseph Sweetman Ames, Joseph John Thomson, Frank Watson Dyson2h 57m3.6 (16)$1 · $0.00
Photographic Reproduction ProcessesPeter C. Duchochois3h 56m$2 · $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
The Every-Machine Bread Maker CookbookCerys J. Chamberlain11h 10m$11.50
Vermeer and His TimePhilip L. Hale3h 11m$18 · $0.00
FusangCharles G. Leland5h 6m3.8 (35)$21 · $0.00
Groundwork of the Metaphysics of Morals (Annotated)Immanuel Kant5h 5m$2 · $0.00
The discovery and decipherment of the trilingual cuneiform inscriptionsArthur John Booth15h 7m$1 · $0.00
Old Glass and How to Collect itJ. Sydney Lewis2h 55m$1.50 · $0.00
Unpermitted Work and Retroactive PermitsImad Muratspahic3h 59m$14 · $0.00