To rename logical file name entries in SQL Server, use ALTER DATABASE with MODIFY FILE and NEWNAME. This post builds a demo database, renames both files and checks the result. It also covers names with dots and the two errors that stop a rename.
SQL SERVER – Incorrect Error: Unable to Add Filegroup – A Severe Error Occurred on the Current Command
A client with a huge partitioned database could not add filegroup and got Msg 0, a severe error. Here is how we found the real, much deeper issue.
The money Data Type: Where Division and Rounding Go Wrong
Dividing money by money loses digits before any cast can save them. Here is the one-third demo, and how to find the leftover penny.
Building a Data Dictionary Query From Extended Properties
A plain join quietly hides every column nobody described. See the LEFT JOIN that keeps them, and turn the gaps into a to-do list.
Database File Size Shrinks by Itself? Check Auto Shrink
When a database file keeps getting smaller after you set its size, check Auto Shrink first. This post shows why a size you set later isn’t protected, then gives three checks: the database flag, jobs that shrink, and the default trace. It ends with the fix and the reason shrinking costs more than it saves.
SQL SERVER – Previewing Old Azure Backup Blobs Before Removal with PowerShell
Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.
Finding Which Indexes Use a Custom Fill Factor Setting
Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.