Author: Steve Stedman

Best Practices for Shrinking SQL Server Files Shrinking files in SQL Server is a task that should be approached with caution. While it may seem like a quick fix to reclaim disk space, shrinking can introduce fragmentation and negatively impact performance if not handled properly. Here’s a simple guide to the best practices for shrinking SQL Server files and when it’s appropriate to do so. 1. Avoid Frequent Shrinking Shrinking is not a maintenance task you should do regularly. It …

Shrinking SQL Server Files Read more →

Why My SQL Server Is Slow If you’re wondering, “Why my SQL Server is slow?”, you’re not alone. SQL Server performance issues can disrupt critical business operations, delay projects, and frustrate users. A slow SQL Server often points to underlying issues that can be diagnosed and resolved with the right approach. In this blog post, we’ll dive into common reasons why your SQL Server is slow, provide an in-depth look at each cause, and share practical steps to identify and …

Why my SQL Server is Slow? Read more →

Query to Check Compatibility Level in SQL Server Upgrading SQL Server to a newer version, such as SQL Server 2019 or 2022, requires verifying and updating the compatibility levels of your databases. Compatibility levels control database behaviors and enable certain SQL Server features, making them a crucial part of your upgrade process. In this guide, we’ll explore how to check compatibility levels, update them, and automate the process for multiple databases. We’ll also cover the compatibility level for SQL Server …

Query to Check Compatibility Level SQL Server Read more →

= 2 THEN a.used_pages ELSE 0 END) * 8 AS IndexSpaceKBFROM sys.tables tINNER JOIN sys.partitions p ON t.object_id = p.object_idINNER JOIN sys.allocation_units a ON p.partition_id = a.container_idGROUP BY t.nameORDER BY TotalSpaceKB DESC; What the Query Does This query calculates: TotalSpaceKB: The total space allocated for each table, including data, indexes, and unused space. UsedSpaceKB: The space actively used by data and indexes. UnusedSpaceKB: The difference between the allocated space and the used space, representing room for growth. DataSpaceKB: The size …

Table Sizes in SQL Server – options Read more →

The Importance of a SQL Server Performance Assessment by Stedman Solutions Maintaining your SQL Server’s performance is essential in today’s fast-paced, data-driven world. At Stedman Solutions, we understand how critical your SQL Server is to your business’s success. That’s why we offer comprehensive performance assessments tailored to your environment. It all begins with a free 30-minute consultation to explore how we can address your unique SQL Server challenges and goals. Keeping Your SQL Server in Prime Condition A properly maintained …

Stedman SQL Server Performance Assessment Read more →