In SQL Server, a spill to TempDB occurs when an operator in a query execution plan requires more working memory than was granted by the… Read More »Understanding TempDB Spills in SQL Server Execution Plans
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU24 for 2022 (16.0.4245.2 – March 2026) CU23 + GDR (16.0.4240.4 – March… Read More »New SQL Update from Microsoft
In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes.… Read More »Dangers of Removing Indexes
Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2… Read More »New SQL Update from Microsoft
Have you ever found yourself scratching your head, trying to remember the difference between a LEFT OUTER JOIN and a RIGHT OUTER JOIN? Or maybe… Read More »Master SQL Joins with Our Free T-SQL Join Types Poster Download
Scale Your Business worry-free! Join Managed Services at Stedman Solutions and Reclaim Your Time. In the dynamic landscape of today’s economy, scaling a business is… Read More »Scale Your Business
Is Your SQL Server Backup and Recovery Strategy Really Up to the Task? Disaster can strike at any moment—a Ransomware attack, a hardware failure, or… Read More »SQL Server Backup and Recovery: Is Your Strategy Ready for Disaster?
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: PREEMPTIVE_OS_GETCOMPRESSEDFILES
Mastering SQL Server Performance: An Insightful Journey with Stedman Solutions Welcome to the Stedman Solutions blog! I’m Steve Stedman, and today I’m thrilled to share… Read More »SQL Server Performance Assessment with Stedman Solutions
Have you seen our SQL short course on the TSQL Output Clause? The SQL Server output clause is a great way to get data back… Read More »TSQL Output Clause Course