Author: stevestedman

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 »

You can download the free trial of Database Health Monitor at http://DatabaseHealth.com/download2. The Risks of Storing User Tables in MSDB: Insights from Database Health Monitor When managing SQL Server environments, it’s crucial to understand best practices and potential pitfalls. One such pitfall is the storage of user tables in the MSDB database. While it might seem convenient or harmless, this practice can lead to several issues. In this post, we’ll explore why putting user tables in MSDB is a bad …

The Risks of Storing User Tables in MSDB Read more »