Privacy Policy

We value your privacy. This policy explains what personal data we collect and why.
What We Collect

Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...

How much space can I expect to recover from a rebuild after dropping a column?

In my last article - Identify Tables With Dropped Columns - we saw how we can identify tables that have columns that were dropped. Today, we are going to...

Identify Tables With Dropped Columns

On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...

What happens when we drop a column on a SQL Server table? Where's my space?

This article was initially posted on SQLServerCentral @ 2024-04-26.
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable.
But, most importantly - The record/table size will remain...

Check Azure SQL DB Space Used

A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill.
To check my progress I needed to...

Query Store: How to open multiple instances of the 'Tracked Queries' dashboard

At the beginning of this week, I shared how you can Search for queries with Query Store GUI .
Today I want to share something, Query Store related, that bugged...

Search for queries with Query Store GUI

Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...

dbatools - Exceptions

Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....

dbatools - Rich Datatypes

Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...

A (big) SQLPackage caveat

Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just...