CXCONSUMER and CXPACKET Waits.
CXCONSUMER and CXPACKET are associated with parallelism. When a query that has a cost beyond the cost threshold for parallelism then that query will be… Read More »CXCONSUMER and CXPACKET Waits.
CXCONSUMER and CXPACKET are associated with parallelism. When a query that has a cost beyond the cost threshold for parallelism then that query will be… Read More »CXCONSUMER and CXPACKET Waits.
Pre-Register For My NEW Exclusive Performance Training! I used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips… Read More »Pre-Registration is Open – Free Weekly Performance Training
When I first created this JOIN Types poster or cheat sheet back in 2013 I didn’t realize there was such a need for it. I… Read More »JOIN Types Poster Applause
Here listed is the current percentages of SQL server versions running our Daily SQL monitoring service with Database Health Monitor. Compare this month’s percentages to Last Month’s… Read More »Daily SQL Monitoring – SQL Server Versions for April
Current Stedman Solutions SQL Course Coupon Codes. Save Up to 65% Off our Popular Online SQL Server Courses, a Once a Year Type Savings! 65%… Read More »SQL Course Coupon Codes
When you hear checkdb repair_allow_data_loss it can sound like a good thing, but please read on, that is not at all true. So, you have… Read More »Beware – REPAIR_ALLOW_DATA_LOSS Vs REPAIR_REBUILD
If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions can help. With the amount… Read More »New SQL Update or SP from Microsoft
Joining tables in SQL Server can be confusing and hinder your performance. I know because I have helped many confused people to understand their JOINs.… Read More »Understanding JOINs Month
Seven Years at Stedman Solutions This week marks my 7th anniversary of Stedman Solutions, LLC being my full time job and my primary source of income.… Read More »March Blog Posts Wrap-up
This week marks my 7th anniversary of Stedman Solutions, LLC being my full time job and my primary source of income. It also happens to… Read More »Seven Years at Stedman Solutions.