Author: Steve Stedman

Need help with this, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. First 5 Things to Check When Your SQL Server is Performing Slowly When your SQL Server begins to lag or perform poorly, it can be a significant hindrance to your business operations. Over my years of experience since 1990 with SQL Server, I’ve come across several common culprits that tend to affect performance. Here are the first 5 …

First 5 Things to Check When Your SQL Server is Performing Slowly Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Risks: User Tables in the Master Database and Disaster Recovery When it comes to managing SQL Server, the master database stands out as one of the most critical system databases. It holds essential system-level data, including server-wide configurations and the existence of other databases. Given its importance, it’s understandable why any conversation about disaster recovery will inevitably …

User Tables in the Master Database Read more »

Steve Stedman here from Stedman Solutions, LLC. If you’ve ever grappled with the complexities of SQL join types, I’ve got something exciting for you. We’re offering a FREE downloadable poster that breaks down the intricacies of SQL joins into an easy-to-understand format. It’s perfect for both beginners and seasoned professionals looking to refine their skills. What’s in the Poster? This beautifully designed poster provides a comprehensive guide to the different types of SQL joins, including: Inner Join Left Outer Join …

Unlock the Power of SQL Joins with Your Free Downloadable Poster! Read more »

Need help with this, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. 3 Essential Checks for Diagnosing a Slow SQL Server Are you struggling with a slow SQL Server? Before you deep dive into the complex world of performance tuning, there are three primary areas you should inspect first. These initial checks often reveal the most common culprits behind performance degradation. Here’s a straightforward guide to help you identify and …

3 Essential Checks for Diagnosing a Slow SQL Server Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Importance of Auto Create Statistics in SQL Server Auto create statistics is a critical setting in SQL Server that greatly influences the efficiency and performance of your queries. This feature, when enabled, empowers SQL Server to automatically generate statistics on columns used in predicates, such as in a WHERE clause. These statistics are vital for the Query …

Understanding the Importance of Auto Create Statistics Read more »

Common Uses of TempDB in SQL Server TempDB in SQL Server is a globally available temporary storage area used by the SQL Server Database Engine for various purposes. Here’s a list of the most common uses of TempDB: User Objects: Includes user-defined temporary tables and temporary stored procedures. Used to temporarily hold data for processing within a session. Internal Objects: Created by SQL Server for its internal operations, including: Work Tables: For cursor or spool operations and storing intermediate results. …

What uses TempDB? Read more »

You can download the free trial of Database Health Monitor at http://DatabaseHealth.com/download2. Navigating SQL Server Performance: The Pitfalls of Percent Autogrowth In the world of SQL Server, performance tuning is an art as much as it is a science. A crucial aspect often overlooked is the configuration of database file growth, specifically the Percent Autogrowth setting. When not managed properly, this setting can lead to not just fragmented files but also extensive locking issues as your database files grow. Let’s …

The Pitfalls of Percent Autogrowth Read more »