Month: April 2026

Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power and versatility of JOINs. From eye-catching JOIN posters to cozy JOIN socks, and from comprehensive JOIN classes to much more, …

April is Join Types Month Read more »

Index fragmentation is one of those performance issues that tends to creep in quietly. You may not notice it right away, but over time it can lead to slower queries, increased I/O, and overall degradation in performance. If your system feels like it is gradually slowing down without an obvious cause, fragmentation may be a part of the story. What is Index Fragmentation? At a high level, index fragmentation refers to how out of order the pages of an index …

Understanding Index Fragmentation in SQL Server (and How to Fix It) Read more »