Author: SteveStedman

Greetings, fellow SQL enthusiasts! Steve Stedman here, thrilled to introduce you to an invaluable resource that will revolutionize your SQL Server experience. At Stedman Solutions, we understand that sometimes a little guidance can go a long way, without the need for a long-term commitment. That’s why we’ve developed our SQL Server Mentoring service—a game-changing option designed to provide you with …

Unlock Your SQL Server Potential with Stedman Solutions’ Mentoring Service Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU28 for 2019 (15.0.4385.2 – August 2024) CU27 + GDR (15.0.4382.1 – July 2024) 2024-08-01 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU14 …

New SQL Update from Microsoft Read more »

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: CXCONSUMER Read more »

Reasons for Queries with Multiple Execution Plans and How to Find Them SQL Server Performance Tuning often involves identifying and optimizing problematic queries. One common issue that can impact performance is when a single query generates multiple execution plans. Understanding why this happens and how to detect these queries can significantly improve your database performance. Let’s delve into the reasons …

Queries with Multiple Execution Plans and How to Find Them Read more »

You only have until the end of the day to get this Database Health Monitor discount of 25% off. This month marks the anniversary of Database Health Monitor. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor but this deal is only good when you purchase before the end of July. …

Last chance saving on Database Health Monitor Read more »

Understanding SHRINKDB in SQL Server: Pros, Cons, and Best Practices Introduction When managing SQL Server databases, one of the tasks that often comes up is the need to reclaim space. This is where the SHRINKDATABASE (SHRINKDB) command comes into play. However, while shrinking a database can seem like a quick fix for storage issues, it’s not always the best solution. …

Shrinking Databases Read more »

With years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. With this month being Database Health Montior month we have a special combo offering. I created the Database Health Monitor course to help people get the most value out of using the product, and with …

Database Health Monitor with Coaching Read more »

So you are checking your database with DBCC CheckDB and of course if you are like me you use the WITH NO_INFOMSGS parameter. But it turns out that CheckDB is taking longer to run that you expected, and you want to check and see what table is currently being checked. Here is a quick SQL Script that I use to …

SQL Server DBCC Commands: Status of DBCC CHECKDB Read more »

The Scan For Startup Procs feature in SQL Server allows you to specify a list of stored procedures that will be automatically executed whenever the database engine starts. This can be useful in certain scenarios, such as when you want to perform tasks such as restoring a database or performing maintenance tasks when the database engine starts. “Scan for startup …

Securing SQL Server: Scan for Startup Procs Read more »

Discover Stedman Solutions: Your Go-To for SQL Server Management In today’s data-driven world, managing your SQL Server environment efficiently and securely is crucial for any business. If you’ve never heard of Stedman Solutions, LLC before, this blog post will introduce you to what we do and explain why we are the best choice for your SQL Server needs. Customer Challenges …

Discover Stedman Solutions Read more »