by Ken Haff | Jul 2, 2025 | Blog, SQL Server
Table of contentsThe Setup: A High-Stakes Data TransferThe First Clue: A tempdb Under SiegeThe Usual Suspects: A Process of EliminationThe Smoking Gun: When Parallelism Turns Against YouThe Final Showdown: Trusting Your GutLessons from the Trenches The Setup: A...
by Ken Haff | Jun 25, 2025 | Blog, Microsoft, SQL Server
Table of contentsA Simple Query with a Devious ProblemWhen Partitioning Works Against YouThe Counterintuitive Fix: Adding a “Duplicate” KeyDon’t Trust the Icon: Read the Real Execution PlanKey Takeaways for Data Professionals A Simple Query with a...
by Ken Haff | Dec 10, 2024 | Blog, SQL Server
EagerZero vs. Quick Format: A Comparison When it comes to formatting drives, there are different methods available, each with its own set of advantages and disadvantages. Two common methods are EagerZero and Quick Format. Here’s how they compare: EagerZero...
by Ken Haff | Sep 24, 2024 | Blog, SQL Server
In SQL Server, the network packet size setting plays a crucial role in determining the data transfer efficiency between the server and clients. This deep dive explores the technical aspects of configuring the network packet size, including how TDS packets are wrapped...
by Ken Haff | Dec 26, 2023 | Blog, Cloud
In this blog post, I will tell you the hilarious story of how XYZ Inc. moved to the cloud without a plan and how it backfired spectacularly. I will also share some tips to avoid making the same mistakes and get the most out of the cloud if you decide to go for it. But...
by Ken Haff | Jun 27, 2023 | Blog, SQL Server
What is the HierarchyID Data Type? Hierarchical data is a common type of data that represents the relationships between entities in a tree-like structure. For example, you may have hierarchical data for your organizational structure, where each employee has a manager...
