Author: Steve Stedman

By Posted on Posted in Uncategorized

SQL Auto Close is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Impact of SQL Server AutoClose Setting on Performance The SQL Server AutoClose database setting, when enabled, can significantly impact the performance of your database. Below are key reasons why: 1. Resource Overhead When the AutoClose setting is enabled, SQL Server will shut down the database after the last user disconnects. This means that every time …

SQL Server AutoClose Impact on Performance Read more »

By Posted on Posted in Uncategorized

February: The Month of Performance at Stedman Solutions! February is here, and at Stedman Solutions, LLC, we’re declaring it Performance Month! As a seasoned expert in SQL Server since 1990, I’m excited to share exclusive opportunities this month to turbocharge your SQL Server’s performance. Here are three pivotal ways you can participate in Performance Month with Stedman Solutions: 1. Free Email Course on Performance Tuning Kick off Performance Month with our free email course on SQL Server performance tuning. This …

February: The Month of Performance at Stedman Solutions! Read more »

By Posted on Posted in Uncategorized

Top 10 SQL Server Wait Types for Performance Tuning Understanding these wait types is key to identifying performance bottlenecks in SQL Server: CXPACKET: Indicates parallelism-related waits. High values suggest inefficiencies in query parallelization. LCK_M_XX: Lock waits (e.g., LCK_M_S, LCK_M_U) signal queries waiting for resource locks, pointing to potential blocking or deadlocking. PAGEIOLATCH_XX: Wait times due to disk I/O operations, indicating possible disk subsystem bottlenecks. SQLCLR: Associated with Common Language Runtime operations. High waits might indicate issues with CLR stored procedures …

Top 10 SQL Server Wait Types for Performance Tuning Read more »

By Posted on Posted in Uncategorized

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Mitigating Slow SQL Server Error Log Access Are you experiencing sluggishness when accessing your SQL Server error log? As a database professional and the owner of Stedman Solutions, LLC, I’ve encountered this issue multiple times and understand how frustrating it can be. Let’s delve into the common reasons for this slow access and explore practical solutions to …

Understanding and Mitigating Slow SQL Server Error Log Access Read more »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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

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

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

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 »