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,192 reads
Cláudio Silva
- Website: https://claudioessilva.eu
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,200 reads
Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,216 reads
2024-03-29
6,399 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,087 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,818 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,291 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,908 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
6,731 reads
Blogs
T-SQL Tuesday #186–Agent Jobs
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
T-SQL Tuesday #186 - Agent Job History Visualization
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
KDA: Echoes of Deception - Case 2
By Zikato
The people of Digitown are being targeted by phishermen, and they need my help...
Forums
Just To Talk – Your Safe Space for Online Therapy
Welcome to Just To Talk, your trusted platform for compassionate, confidential online therapy. At...
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Need help with merging data based on date and process
I have two sources , one coming from datalake and another is file. we...
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers