Author: Steve Stedman

Accessing SQL Server error logs swiftly is crucial for database administrators striving to maintain an efficient and responsive database environment. However, challenges often arise when these logs become colossal in size, slowing down access times and complicating the process of troubleshooting and maintaining system health. This issue affects operational efficiency, making it imperative to adopt strategies that enhance the accessibility and manageability of error logs. In this post, we’ll delve into practical solutions designed to mitigate the delays associated with …

Mitigating Slow SQL Server Error Log Access Read more »

Some people say I am obsessed with Join Types, they may be right, you can decide. Imagine transforming your daily shower ritual into an innovative learning session. As the steam rises, so too can your knowledge of SQL, all thanks to a clever tool aptly named the Shower Curtain. This novel approach aims to seamlessly integrate learning into your routine, allowing you to memorize SQL queries and functions while you lather, rinse, and repeat. Designed for tech enthusiasts and busy …

Shower Curtain: Learn SQL In The Shower Read more »

Why an Active SQL Server Agent Job with No Schedule Can Be Misleading or Confusing An active SQL Server Agent job with no schedule can be misleading or confusing for several reasons: Expectation of Execution: An “active” job implies it is running or will run automatically, but without a schedule, it won’t execute unless manually triggered or called by another process. This can confuse users who expect automated execution. Misinterpretation of Status: The “enabled” status of the job might suggest …

Active Agent Jobs with No Schedule Read more »

Why Disabled Indexes in SQL Server Can Cause Issues Indexes in SQL Server are essential for query performance, but disabled indexes can lead to significant problems. This post explores the risks of disabled indexes, why they occur, and how tools like Database Health Monitor can help identify them. What Are Disabled Indexes? In SQL Server, indexes can be disabled using the ALTER INDEX … DISABLE command. When disabled, SQL Server no longer uses the index for queries or maintains it …

Disabled Indexes Read more »

Configuring Database Mail in SQL Server Database Mail is a powerful tool in SQL Server that enables you to send emails directly from your server. This functionality is essential for automation and monitoring, allowing for seamless integration of email notifications when certain criteria are met within your database activities. Whether it’s sending alerts for low disk space or notifying administrators of job completions, setting up and configuring Database Mail ensures you stay informed on your database’s activities without the need …

Configuring Database Mail in SQL Server Read more »

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. CTRL + Mousewheel Support Database Health Monitor has support for adjusting font sizes using the CTRL + Mousewheel to scroll up or down to resize fonts, this option is available in many of the edit/display fields. Database administrators and analysts continuously seek tools and features that enhance the user experience and streamline workflows. One such feature, often …

CTRL Mousewheel to Adjust Fonts in Database Health Montior Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. In the world of data-driven decision-making, the ability to efficiently analyze and utilize vast amounts of information has become a cornerstone of successful business operations. At the heart of this capability lies the critical function of database management systems. One of the unsung heroes within this sphere is the feature known as “Auto Create Statistics.” While it may not …

The Importance of Auto Create Statistics Read more »

Virtual Log Files (VLFs) in SQL Server are smaller, manageable segments of the physical transaction log file used to track database changes for recovery and consistency. When a transaction log grows, SQL Server divides it into VLFs to simplify log management, with each VLF handling a portion of the log records. The number and size of VLFs depend on the log file’s initial size and growth increments, and having too many or too few can impact performance—excessive VLFs cause fragmentation, …

Virtual Log File – Video Read more »