When it comes to managing and troubleshooting databases in SQL Server, the transaction log is a treasure trove of information. It holds the key to… Read More »Exploring fn_dump_dblog: A Deep Dive into SQL Server Transaction Log Analysis
The Hidden SQL Server Performance Killer: Implicit Conversions When SQL Server Performance issues begin appearing, many companies assume the only solution is to add more… Read More »The Hidden SQL Server Performance Killer: Implicit Conversions
This chapter refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation,… Read More »SQL Server DBCC Commands: Shrinking Notes
Delving into the intricacies of SQL Server, the T-SQL WAITFOR command emerges as a unique tool for managing the timing of script executions. Often overlooked,… Read More »Mastering the T-SQL WAITFOR Command in SQL Server: A Guide to Timing Control
Data aggregation techniques is one of the most practical skills any SQL Server professional can develop, turning raw tables filled with thousands of rows into… Read More »Data Aggregation in SQL Server: Master SUM, COUNT, AVG, GROUP BY and More
Is your SQL Server dragging down your business with sluggish performance and inefficiencies? Poor database performance can lead to frustrated users, delayed operations, and missed… Read More »SQL Server Performance Consulting: Boost Database Efficiency with Expert Solutions
Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2… Read More »New SQL Update from Microsoft
When working with SQL Server, database administrators and developers often encounter scenarios where SQL Server Performance Tuning performance and data consistency must be carefully balanced.… Read More »NOLOCK vs READ UNCOMMITTED in SQL Server: Key Differences and Best Practices
One of the most satisfying parts of my job at Stedman Solutions is when we can help a customer repair a corrupt database that without… Read More »SQL Server Corruption: What Can Get Corrupted
When it comes to maintaining a robust SQL Server environment, patching is a critical yet often daunting task. The decision to apply updates can feel… Read More »SQL Server Patching Risks: Why It Matters and How Stedman Solutions Helps