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% Off for April JOINs Month Coupon Code: APRIL-JOINS Leave your JOIN confusion in the past and enroll in our SQL Server JOIN Types Course. Learn More Here 50% Off Our Newest Course! Coupon Code: FEB-RELEASE50 …

SQL Course Coupon Codes Read more »

Sometimes we all need a little help without a long term commitment. That why we created our SQL Server Mentoring service at Stedman Solutions. SQL Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those who need just a little help. Some call it coaching, …

SQL Server Mentoring – Do you need a little help? Read more »

SQL Server 2019 CU 16 (KB 5011644) 4/18/2022(Windows only) Here are the most up to date versions of SQL Server. SQL Server 2019 RTM CU 16Download links:CU 16 (KB 5011644)   SQL Server 2017 RTM CU 29Download links:CU 29 (KB 5010786)   SQL Server 2016 SP2 CU 17Download links:SP2 (KB 4052908)CU 17 (KB 5001092)   SQL Server 2014 SP3 CU …

New SQL Update or SP from Microsoft Read more »

Top reasons for slow SQL Server performance I typically see are: Slow Running Queries, these are queries that run slow even with just one user in the database. Caused by poorly written queries. Caused by missing indexes. > See Database Health Monitor Missing Indexes Report. Caused by out of date statistics for your indexes. Many other reasons. Blocking Queries, where …

Common Performance Issues on SQL Server Read more »

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 split out to be worked on by multiple cores. This is a good thing. It usually means that your queries are taking advantage of multiple cores. Reducing your max degree of parallelism setting is not …

CXCONSUMER and CXPACKET Waits. Read more »

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 and tricks into this training. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put the horse …

Pre-Registration is Open – Free Weekly Performance Training Read more »

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 originally made this as a tool to explain JOIN types to a fellow coworker. It seemed almost impossible teach JOIN without it. The inspiration to create this tool came from a little bit of frustration. …

JOIN Types Poster Applause Read more »

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 Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie chart above represents all of our current customers using our service and what SQL Server versions they are running. …

Daily SQL Monitoring – SQL Server Versions for April Read more »

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% Off for April JOINs Month Coupon Code: APRIL-JOINS Leave your JOIN confusion in the past and enroll in our SQL Server JOIN Types Course. Learn More Here 50% Off Our Newest Course! Coupon Code: FEB-RELEASE50 …

SQL Course Coupon Codes Read more »