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...
2024-07-15 (first published: 2024-07-09)
90 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
913 reads
Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
1,882 reads
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...
2024-05-29
212 reads
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...
2024-05-02
110 reads
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-04-26
2,928 reads
2024-03-29
2,103 reads
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...
2024-02-16 (first published: 2024-02-01)
335 reads
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...
2024-02-09 (first published: 2024-01-29)
599 reads
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....
2022-06-27 (first published: 2022-06-07)
349 reads
Blogs
Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu SWAT tým
The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu...
MVP No more, But It’s OK
Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...
A New Word: Fitching
By Steve Jones
fitching – v. intr. compulsively turning away from works of art you find frustratingly,...
Forums
Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Updating a Cryptographic Provider for...
Cloud vs On-premises
Comments posted to this topic are about the item Cloud vs On-premises
Query Store for DDL
Comments posted to this topic are about the item Query Store for DDL
Question of the Day
Query Store for DDL
How do I configure Query Store to capture plans for CREATE and ALTER DDL commands in SQL Server 2022?
See possible answers