Year: 2024

By Posted on Posted in Uncategorized No Comments

The Power of Proactive Monitoring in a World of Constant Change As the world continually evolves, the need for robust and proactive solutions in the realm of IT managed services becomes ever more critical. In an environment where a single change can have cascading effects, businesses cannot afford to be reactive. This is where Stedman Solutions steps in with its cutting-edge managed services offering, featuring the daily checkup monitor – a tool designed to catch changes as they occur, ensuring …

Proactive Monitoring in a World of Constant Change Read more »

By Posted on Posted in Uncategorized No Comments

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 »

By Posted on Posted in Uncategorized No Comments

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index management and discuss strategies to identify and remove unnecessary indexes without compromising system stability. The Dilemma of Too Many Indexes …

Dangers of Removing Indexes Read more »

By Posted on Posted in Uncategorized No Comments

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 »

By Posted on Posted in Uncategorized No Comments

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 »

By Posted on Posted in Uncategorized No Comments

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 »

By Posted on Posted in Uncategorized No Comments

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 »