Author: Steve Stedman

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 »

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 »

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 »

Enhance Your Database Performance with Stedman Solutions, LLC‘s SQL Server Health Assessment In today’s fast-paced digital world, your data is your most valuable asset. Ensuring that your SQL Server is running at peak performance is not just an IT concern; it’s a business imperative. Stedman Solutions, LLC offers a comprehensive SQL Server Health Assessment designed to optimize your database’s performance, security, and scalability. Here are ten compelling reasons why your business needs this service: 5 Reasons to Get a SQL …

SQL Server Health Assessment from Stedman Solutions Read more »

Master SQL Server with Our SQL Performance Tuning Course If your SQL Server environment is underperforming, struggling with slow queries, or simply not meeting the demands of your business, it’s time to take action. The right training can make all the difference, and that’s where the SQL Performance Tuning Course from Stedman Solutions, LLC comes in. With decades of experience in SQL Server optimization, we’ve designed this course to help database professionals of all skill levels unlock the full potential …

SQL Performance Tuning Course Read more »

Balancing Index Management in Database Performance Optimization When it comes to optimizing database performance, index management is one of the most impactful areas to focus on. Proper indexing can drastically improve query performance, reduce resource usage, and ensure your SQL Server is running smoothly. However, improper index management can lead to bloated storage, maintenance overhead, and even degraded performance. So, how do you strike the right balance? Need help with this, try a free no risk 30 minute consultation with …

Index Management in Database Performance Read more »

SQL Server Defragmentation Best Practices – By Steve Stedman Fragmentation in SQL Server can significantly impact query performance, increasing I/O overhead and slowing down data access. Proper defragmentation ensures that your database operates efficiently, minimizing unnecessary reads and writes. In this blog post, we’ll explore SQL Server defragmentation best practices, focusing on why it matters, how to identify fragmentation, and the most effective ways to address it. What Is Fragmentation in SQL Server? Fragmentation occurs when the logical order of …

SQL Server Defragmentation Best Practices Read more »

In the intricate world of SQL Server, understanding various wait types is crucial for database Performance Tuning. One such wait type, often encountered but not always well-understood, is the LCK_M_IU. This blog post aims to demystify the LCK_M_IU wait type, shedding light on its causes, diagnosis, and resolution strategies. At Stedman Solutions, we specialize in SQL Server performance tuning, and if you’re struggling with waits like LCK_M_IU, our Managed Services can help identify and resolve these bottlenecks quickly. Learn more …

Unlocking the Mystery of the LCK_M_IU Wait Type in SQL Server Read more »