Category: SQL Server

How to regain space after dropping columns in SQL Server

I hit an annoying issue today. I wanted to regain space after I dropped several columns in a table. When I run the famous query from StackOverflow:

I got a set of numbers which were the same before and after the removal has

There is, however, a potential issue with this approach if

Continue Reading

Transaction log is full due to LOG_BACKUP

Yesterday, when I was building a large DB from scratch I got an error saying:

Running this simple query solved the issue:

Continue Reading