There are many ways to increase SQL performance, some of the most common and effective include: It’s worth noting that these methods are not mutually exclusive, and the best approach will depend on the specific needs of your application and the characteristics of your dataset. Learn the techniques to boost your SQL performance……….. With our FREE SQL Server Performance Tuning Email …

Ways to Increase SQL Server Performance Read more »

Why is SQL Server performance important? SQL performance is important because it directly affects the speed and efficiency of a database system. Poor performance can lead to slow query times, resulting in a poor user experience and decreased productivity. Additionally, as data sets grow larger, the impact of poor performance becomes even more pronounced, resulting in increased costs for additional …

SQL Performance Training Opportunity Read more »

In this free training I have poured my 30+ years of SQL Server experience and personally curate my favorite performance tuning tips, tricks and tactics. 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 some speed back into their SQL Server. …

SQL Performance Tuning Training Read more »

Only one more week to claim your free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. This once a year deal will soon be gone. For the month of October we are offering a free add-on for anyone who purchases a Server Assessment from Stedman Solutions. From October 1st to October 31, with …

Final Week to Seize This Offer! Read more »

For the month of October we are offering a free add-on for anyone who purchases a Server Assessment from Stedman Solutions. From October 1st to October 31, with the purchase of server assessment, you will also receive for no additional charge 1 full year of our SQL Daily Monitoring product. If your assessment is for one SQL Server you will …

Receive a full year of Daily SQL Monitoring FREE Read more »

Follow along as Steve teaches you how to find and track IO on your SQL Server. We’ll look at IO by database, IO by drive and IO by hour. Transcription of Video: Welcome to this short video on database health monitor and analyzing IO. With what you learned in this lesson, you’ll be able to go and find which databases …

Tracking Server IO with Database Health Monitor Read more »

Over the last 30+ years of working with SQL Server, I have seen a lot of interview questions relating to SQL Server. I have been on both sides of the interview table, sometimes wondering what the person on the other side of the table was asking. As a SQL Server developer do you feel that you were asked good questions …

What is your favorite SQL Server Developer Interview questions? 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 »

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 »

Every time I do a performance training class I share some stories about those long running reports that I was able to speed up by simply switching a Table Variable (declared with the @ sign) to a Temp Table (declared with the # sign). Today I was working on a batch of TSQL code that took about 8 minutes to …

Table Variable Vs. Temp Table Read more »