The Backup Space Needed

SQL Server 2022 CU Updates and Error Code 0x851A0043

The documentation cautions that cumulative updates (CU) could fail if a specific registry key isn’t updated after moving the master files, so I wanted to test this before I spent too much time configuring the server.

Tracking Table Sizes

Today Steve asks if you track the details of your table growth inside a database.

How to rename a SQL Server database

There may come a time when you want to or need to rename a database. In this tip we look at a couple different options.

Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE

Learn how to quickly and efficiently attach multiple SQL Server databases using the undocumented DBCC CHECKPRIMARYFILE command. Automate the process with minimal effort, saving time and reducing errors.

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.

Resolving Access Denied Errors During SQL Server Database Attachment

Learn how to resolve access denied errors when attaching databases in SQL Server. This guide explores file permission settings, focusing on the differences between Windows and SQL logins, and provides a step-by-step solution to prevent common attachment issues.

How to Attach and Detach Databases in SQL Server

Learn how to effectively attach and detach databases in SQL Server, exploring the differences between these methods and traditional backup and restore procedures. Streamline your database management tasks with clear, step-by-step instructions.

SQL Server Forced Plans Overwite the Query Hash

A 16-year old SQL Server bug that means 'forced plans' have the query plan hash in place of the expected query hash. Includes an explanation and discussion of the term 'morally equivalent plan'.

Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

This article shows how to attach an MDF with or without a log file.