Have you heard of SchemaDrift, our Database Comparison Tool? It’s free to use! Download this tool today! Save yourself Time and Money with Steve Stedman’s database comparison tool. Following in its cousin’s (Database Health Monitor) footsteps, SchemaDrift is FREE! It is currently in Beta phase but, free to download for personal or business use. We only ask that you give …
A great way to keep tabs on the overall health of your SQL Server. Pricing: $129.99 per month per SQL Server instance when paid month to month. Payment on a recurring payment by credit card plan required. We provide monitoring tools that alert us when there is an issue so that we can recommend fixes before the issue becomes a …
SQL Course Coupon Codes Fri, 22 Apr 2022 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 pas Read more… SQL Server Mentoring – Do you need a little help? …
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 …
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 …
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 …
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 …
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. …