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
Frosty: The incredible true story of the boy from Doonside who became a Bathurst kingMark Winterbottom8h 9m4.8 (50)$26 · $0.00
Cadillac Desert, Revised and Updated EditionMarc Reisner27h 56m4.4 (13.6K)$30
The Honey BusMeredith May9h 31m4.4 (16.6K)$25 · $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 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
Mars Rover CuriosityRob Manning, William L. Simon7h 43m4.3 (1.7K)$20
Across the Airless WildsEarl Swift10h 8m4.3 (1.3K)$29 · $0.00
You may also like
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
Paint Technology and TestsHenry A. Gardner5h 32m$1 · $0.00
Popular Astronomy: A Series of Lectures Delivered at IpswichGeorge Biddell Airy8h 53m$2 · $0.00
The Earliest Electromagnetic InstrumentsRobert A. Chipman1h 13m$2 · $0.00
Meteoric astronomy: A treatise on shooting-stars, fire-balls, and aerolitesDaniel Kirkwood2h 47m$2 · $0.00
The coins of IndiaC. J. Brown4h 26m4.0 (17)$1 · $0.00
From Newton to Einstein - The Changing Conceptions of the UniverseBenjamin Harrow, Albert Einstein, Arthur Stanley Eddington, Joseph Sweetman Ames, Joseph John Thomson, Frank Watson Dyson3h 8m$1.99 · $0.00
Studies of Birds Killed in Nocturnal MigrationHarrison Bruce Tordoff, Robert Morrow Mengel32m$2 · $0.00
Astronomy: The Science of the Heavenly BodiesDavid P. Todd11h 5m3.9 (48)$2 · $0.00
The TelephoneA. E. Dolbear2h 18m$2 · $0.00
The Craft of FictionPercy Lubbock8h 7m3.7 (109)$2 · $0.00
Who Wrote the Bible? : a Book for the PeopleWashington Gladden9h 46m4.0 (69)$2 · $0.00
A select glossary of English words used formerly in senses different from their presentRichard Chenevix Trench11h 5m$2 · $0.00
Astronomical Curiosities: Facts and FallaciesJ. Ellard Gore9h 40m$1 · $0.00
Ex Voto: An Account of the Sacro Monte or New Jerusalem at Varallo-SesiaSamuel Butler6h 2m$1 · $0.00
An Expository Outline of the "Vestiges of the Natural History of Creation"S. Laing2h 48m$2 · $0.00
Pleasures of the TelescopeGarrett Putman Serviss5h 24m3.8 (40)$2.30
The World Before the DelugeLouis Figuier13h 22m$2 · $0.00