Blindsided by Database Corruption
Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t
September 20, 2023
Author: Rich Benner
Parallelism in SQL Server
Parallelism in SQL Server can significantly improve query performance by allowing multiple processors or cores to work together.
July 12, 2023
How To: Clear Backup History
SQL Server should clear up system tables, but doesn’t. And that’s a problem. This post shows you how to clear backup history.
June 13, 2023
SQL Server and the (not so mysterious) Mystery of Three-Valued Logic
SQL Server’s three-valued logic is a concept that extends the traditional two-valued logic to include a third value, known as NULL. Three-valued logic is used to handle cases where the value of a column in a database table is unknown or not applicable. Get to grips with this complex idea.
April 21, 2023