دانلود کتاب تنظیم عملکرد پرس و جو در SQL Server 2025، ویرایش هفتم

It’s never easy to “introduce” you to six to nine months of work. The concept of an introduction is simple enough: what’s the purpose of the book, who is the book written for, tips on how best to use the book. However, the introduction also has to set the stage for the rest of the book. As you’ll see when you read it, I open and close the book with a simple concept: query tuning is hard. When I present live sessions on this topic, I’ll tell people up front. The easy way to tune queries is to simply throw money at the problem. Buy bigger hardware. Move to a higher service tier on your cloud provider. You can always make things faster by spending more money. It’s when the money runs out that you might just need to spend something else, time. Time learning how to identify poorly performing queries, understand how to investigate them to see where the problem may lie, and then apply a fix and validate that it worked. That’s where this book comes in. I truly don’t care what your title is. More and more, I see titles changing, rapidly. Yet, there’s going to be a person responsible for making queries run faster. You may not want the job, it may be called any number of things, but at the root, the problem remains, which queries are problematic and how to make them not be. This book is for that person. You wrote some code, found some generated by a tool, who knows what the source may be. However, that code is running slow, and you need to figure out how to make it run fast. This is your book. Your title doesn’t even enter the question. The very best way to use the book is as a straight-through read. Many of the chapters build on knowledge from preceding chapters. However, an alternate way that could work for lots of people would be to read Chapters 1–10. They lay the foundations for most query behaviors and how to monitor those queries. The rest of the chapters are problem, or behavior, specific, so if you’re not hitting that problem, or using that feature, you can safely skip that chapter, for the moment. Then read Chapter 23. It’s not strictly a checklist, although I tried to make it as much like a checklist as I could. Or bounce around. Many of the chapters are largely stand-alone. It’s kind of like query tuning: if it works for you, that’s great.