Month: June 2024

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS MEMORY_ALLOCATION_EXT SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_S LCK_M_IX LCK_M_IS LCK_M_U Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

Learn how a worktable table applies in the realm of SQL Server, efficient query processing and resource management are crucial for maintaining performance and reliability. One of the often-overlooked components that play a vital role in query execution is the worktable. In this blog post, we’ll delve into what worktables are, how they function, and why they are important for …

What is a Worktable in SQL Server Read more »

Converting data types is a common task in SQL Server, especially when dealing with data imports or migrations where data might not be in the desired format. One frequent requirement is converting text data to integer data types. In this blog post, we’ll explore various methods for converting text to integers in SQL Server, discuss potential pitfalls, and provide best …

Converting Text to Integer in SQL Server Read more »

One of the fundamental aspects of working with SQL Server is understanding how to get the number of rows affected by a query. Whether you’re working with SELECT, INSERT, UPDATE, or DELETE statements, knowing the row count can provide critical insights into your database operations. In this blog post, we’ll explore different methods to retrieve the row count in SQL …

Understanding SQL Query Row Count in SQL Server Read more »

Have you seen our Managed Services offering? Managed Services for SQL Servers has become one of the largest parts of our business, and we have even expanded the managed services team now to 4 people supporting clients SQL Servers. A short video where I describe the managed services offering that we have at Stedman Solutions to support SQL Servers. We …

Have you seen our Managed Services offering? Read more »

Understanding RPO and RTO with SQL Server In the realm of SQL Server management, two crucial concepts that every DBA and IT manager must understand are Recovery Point Objective (RPO) and Recovery Time Objective (RTO). These metrics are pivotal in planning for disaster recovery and ensuring business continuity. Let’s dive into what RPO and RTO mean, how they apply to …

Understanding RPO and RTO with SQL Server Read more »

There are 2 perspectives here to the DBA on vacation, typically in an organization with only a single DBA so there is no cross coverage when someone goes on vacation. The view as the DBA: I have done everything that I can to prepare the systems for vacation, but still I end up getting called for some regular maintenance job …

DBA on Vacation Read more »

If you are reading this article becuase you are trying to repair your corruptin database, please reach out ot us at Stedman Solutions we can take a quick look and help determine your options for reparing the database. Contact us for a free 30 minute consultation. These stories come from a recording of a presentation by Steve Stedman and Derrick …

SQL Server Corruption: Stories About Causes of Corruption Read more »

Unlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical operations. That’s where Stedman Solutions, LLC, steps in. We offer flexible, fully managed services tailored to the unique demands of your SQL Server environment. Our elite SQL …

Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed Services Read more »