NOLOCK Hint in SQL Queries: Myths, Misconceptions, and Best Practices In the world of SQL Server, the NOLOCK hint often generates spirited debates among database professionals. This hint is frequently used but equally misunderstood. In this blog post, we’ll explore …
Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an …
Blocking Query Monitor – Part of Database Health Read more »
Why are there so many backup messages in my sql server logs? SQL Server logs contain a wealth of information about the server’s operation, including details about backup operations. This data can be quite helpful for various administrative tasks like …
When working with data in SQL Server, there may be times when you need to remove leading zeros from a string. This task can be particularly common when dealing with numerical data stored as strings, such as ZIP codes, product …
Shrinking a database can seem like a helpful way to save space and resources, particularly if a database has grown substantially over time. However, SQL Server’s default maintenance plans that include database shrinking can lead to several performance issues. Here’s …
Database Health Quickscan – Default maintenance plans to shrink database – Ouch Read more »
Welcome to July – a month that signifies a shift in focus to the unseen heroes of our digital infrastructure – our databases. As the founder of Database Health and Stedman Solutions, it is with great pleasure that I announce …
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 …
Exploring Example SQL Databases in SQL Server SQL Server is a robust relational database management system that offers a variety of features for data management, analysis, and reporting. One of the great resources for learning and testing SQL Server capabilities …
July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this …
Sneak preview – July is Database Health Monitor Month Read more »
Over the years developing Database Health Monitor I have added a number of keyboard shortcuts to make life easier when working in the application. Some of these are listed here to share since they are not all completely obvious. Backspace …