Answering Questions On Dropped Columns
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2026-04-19
4 reads
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2026-04-19
4 reads
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
2,012 reads
We value your privacy. This policy explains what personal data we collect and why.
What We Collect
Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...
2025-04-14
13 reads
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2025-03-10
3 reads
In my last article - Identify Tables With Dropped Columns - we saw how we can identify tables that have columns that were dropped. Today, we are going to...
2024-08-05
25 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,907 reads
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-22 (first published: 2024-07-09)
359 reads
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,237 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,573 reads
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
264 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers