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
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
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,200 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,216 reads
2024-03-29
6,399 reads
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
2,087 reads
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,818 reads
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
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
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
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
By Zikato
The people of Digitown are being targeted by phishermen, and they need my help...
Welcome to Just To Talk, your trusted platform for compassionate, confidential online therapy. At...
--for a given member if the startdate and endate is continous we need to...
I have two sources , one coming from datalake and another is file. we...
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