Month: January 2025

By Posted on Posted in Uncategorized No Comments

SQL Server errors 823, 824, and 825 are critical indicators that your system is having trouble accessing data in your database files. These errors often point to underlying issues with disk I/O, hardware, or storage subsystems, and can range from transient problems to signs of serious corruption. Understanding these errors, their causes, and how to address them is crucial for maintaining a stable and reliable SQL Server environment. SQL Server Error 823: The Operating System Returned an I/O Error Error …

SQL Server Errors 823, 824, and 825 Read more »

By Posted on Posted in Uncategorized No Comments

Index maintenance is an essential part of SQL Server performance tuning, but it needs to be performed carefully to avoid negative impacts on your production environment. Rebuilding or reorganizing indexes during the day, when your database is under heavy usage, can lead to serious issues, including degraded performance, contention, and even application timeouts. Let’s dive into the reasons why this task is best scheduled during maintenance windows or low-usage periods. 1. Performance Impact on Query Execution Rebuilding or reorganizing indexes …

Why You Should Avoid Rebuilding or Reorganizing Indexes During the Day in SQL Server Read more »

By Posted on Posted in Uncategorized No Comments

Ensuring Data Security with Stedman Solutions SQL Server Managed Services: Solid Backups and Restores In today’s data-driven world, the integrity and availability of data are paramount. For businesses relying on SQL Server for their critical data storage and management, ensuring solid backups and reliable restores is not just an option, it’s a necessity. This is where Stedman Solutions’ SQL Server Managed Services shine, offering comprehensive coverage to protect your data with robust backup and restore strategies. The Pillars of Data …

Solid Backups and Restores Read more »

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

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

Managing a SQL Server environment extends beyond routine maintenance. It demands a proactive strategy for optimal performance and reliability. A pivotal element of this approach is the thorough SQL Server Health Assessment, focusing on monitoring and alerts for specific errors and severity levels. Understanding the Need for Alerts Alerts for severity levels 19 to 25 and errors 823, 824, and 825 are crucial in your SQL Server Health Assessment. These represent serious system issues. Severity levels 19 to 25 indicate …

SQL Health Assessment and Configuration of Alerts Read more »

By Posted on Posted in Uncategorized No Comments

Understanding the GFS BACKUP Schedule and How It Can Work with SQL Server When managing SQL Server databases, having a robust backup strategy is crucial. While SQL Server offers built-in tools for backups, leveraging a Grandfather-Father-Son (GFS) backup schedule can significantly enhance your backup strategy by providing a layered approach to data retention and recovery. In this blog post, we’ll explore how the GFS backup schedule works, why it’s an excellent fit for SQL Server environments, and how you can …

GFS Backup Schedule Read more »

By Posted on Posted in Uncategorized No Comments

The PRINT_ROLLBACK_PROGRESS Wait Type in SQL Server Need help with this wait type or others, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. The SQL Server PRINT_ROLLBACK_PROGRESS wait type is an indicator that a thread is waiting for a rollback operation to complete. Rollbacks occur when a transaction is terminated prematurely, either due to an explicit cancellation by the user, a timeout, or an error that prevents the transaction from …

PRINT_ROLLBACK_PROGRESS Wait Type Read more »

By Posted on Posted in Uncategorized No Comments

The Data Aggregation Class offered by Stedman Solutions, LLC is designed to teach database professionals how to efficiently collect, summarize, and present data using SQL Server. This class focuses on techniques that enable you to extract valuable insights from your data, whether for reporting, analysis, or decision-making. What You’ll Learn: How to use aggregate functions like SUM(), AVG(), COUNT(), MIN(), and MAX(). Writing advanced aggregation queries using GROUP BY and HAVING clauses. Techniques for creating rolling sums, running totals, and …

Data Aggregation Class Read more »

By Posted on Posted in Uncategorized No Comments

SQL Clustered vs Nonclustered Index: Understanding the Difference Indexes are one of the most important features in SQL Server, and they play a significant role in database performance optimization. However, understanding the difference between clustered and nonclustered indexes is essential to making the right design decisions for your database. Both serve different purposes and have unique advantages and use cases. At Stedman Solutions, LLC, we’ve helped many clients optimize their SQL Server environments, often by making smart decisions around indexes. …

SQL Clustered vs Nonclustered Index Read more »