Author: SteveStedman

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 July as Database Health Monitor Month! This is our yearly chance to acknowledge our largely invisible data protectors, and to …

Just past the midpoint of Database Health Monitor Month Read more »

SQL Server Corruption Class – Learn How to Prepare and React Course Link In this video, we introduce our comprehensive SQL Server Corruption class designed to help you prepare your SQL Server environment to reduce the impact of corruption and react effectively if corruption strikes. What is Database Corruption? Corruption in a SQL database occurs when the database becomes damaged …

SQL Server Corruption Class – Learn How to Prepare Read more »

25% Off Database Health Monitor Course in July! Coupon Code: JULY25 Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. With this course you will also receive 10 Database Health Monitor server connection points (10 server connections) that are good for 1 year. Unlock the …

25% off Database Health Monitor this month Read more »

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: CXPACKET Read more »

At DatabaseHealth.com, we understand that monitoring the performance of your SQL Server is critical to ensuring that your databases are running smoothly. Poor performance can impact productivity, lead to lost revenue, and ultimately harm your business. In this article, I’ll discuss how Database Health Monitor can help you optimize the performance of your SQL Server. Identify Performance Issues Database Health …

Improve Performance of your SQL Server with Database Health Monitor Read more »

The SQL ROUNDUP Options Rounding numbers is a common task in SQL Server, and understanding how to round up specifically can be crucial for various applications, such as financial calculations or setting minimum thresholds. In this blog post, we’ll explore different methods to round up numbers in T-SQL. The CEILING Function The simplest and most direct way to round up …

Rounding Up in TSQL 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 what the NOLOCK hint does, dispel some common myths and misconceptions, and provide best practices for its use. Understanding the …

NOLOCK Hint in SQL Queries Read more »

As a database professional, I know first-hand the challenges that come with monitoring and maintaining a database. It can be time-consuming, complex, and, if not done properly, it can lead to costly downtime and lost business opportunities. That’s why I created Database Health Monitor – a powerful tool designed to make database monitoring and optimization easier and more effective. With …

Database Health Monitor Read more »

DBCC CHECKCONSTRAINTS is a database console command (DBCC) in Microsoft SQL Server that can be used to display information about the CHECKCONSTRAINTS on a table or view in a database. CHECKCONSTRAINTS are used to enforce data integrity in a database by limiting the data that can be inserted or updated in a table. To use DBCC CHECKCONSTRAINTS, you must specify …

SQL Server DBCC Commands: DBCC CHECKCONSTRAINTS Read more »