Understanding UPDLOCK
UPDLOCK Hint in SQL Queries: Reasons to Avoid and Best Practices The UPDLOCK hint in SQL Server is used to indicate that the lock obtained on the selected rows is to be held until the end of the transaction. This …
UPDLOCK Hint in SQL Queries: Reasons to Avoid and Best Practices The UPDLOCK hint in SQL Server is used to indicate that the lock obtained on the selected rows is to be held until the end of the transaction. This …
As we cross the midpoint of July, it’s time to shift our focus onto the life force of our digital existence – our databases! Being the founder of Database Health and Stedman Solutions, it brings me immense joy to pronounce …
Just past the midpoint of Database Health Monitor Month Read more »
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 …
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 …
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 …
In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to …