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)
3,275 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,072 reads
Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
1,945 reads
2024-03-29
2,890 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
1,962 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,760 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,201 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,855 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,406 reads
Blogs
Saving Emergency Space on my Laptop
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
T-SQL Tuesday #178–A Recent Technical Problem
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
talend "template" feature vs ssis
Hi we will be using a talend template shortly to abstract the schema definition...
Question of the Day
Setting Emergency State
Which server role(s) can set a database to the Emergency State?
See possible answers