
SQL Server on a Diet: Improve the health of your database
We often see databases that are simply larger than they need to be. This is usually attributable to technical debt
We often see databases that are simply larger than they need to be. This is usually attributable to technical debt
Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t
Parallelism in SQL Server can significantly improve query performance by allowing multiple processors or cores to work together.
SQL Server should clear up system tables, but doesn’t. And that’s a problem. This post shows you how to clear backup history.
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.