Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
2,021 reads
Cláudio Silva
- Website: https://claudioessilva.eu
What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-08-01 (first published: 2024-04-26)
4,914 reads
How much Space can I expect to recover from a rebuild after dropping a column?
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,239 reads
Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,576 reads
2024-03-29
9,052 reads
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
2,182 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,902 reads
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,366 reads
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
2,962 reads
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
7,052 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers