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. …
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 …
So, you have discovered CheckDB is reporting errors on your SQL Server database or on a table in your database. What do you do? REPAIR_ALLOW_DATA_LOSS seems like and quick and easy fix right? But do you actually know what you’re doing? Well, if you read the error messages you might see that repair_allow_data_loss is the minimum repair level for the …
Beware – REPAIR_ALLOW_DATA_LOSS Vs REPAIR_REBUILD Read more »
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 of ransomware we are seeing, it is becoming more important than ever to apply any updates that contain security patches. Microsoft Just Released SQL Server 2017 CU 29 (KB 5010786) Here are the latest updates for each …
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. That is why I created the JOIN Types cheat sheet several years ago, and the JOIN Types class last year. I have recently updated my poster to version 22. I have also made many blog …
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. It also happens to be the 7th anniversary of the last time I got fired. Read more… High Alert – Preparing for a Cyber Attack Recent Cyber attack announced issued by the US Government and the …