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,690 reads
Database Administration
2024-07-31
331 reads
2024-07-22
389 reads
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
2024-07-22
2024-07-10
351 reads
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,141 reads
Getting Your DBA Teams Scripts into Git
In this article, you will learn how a team can start to better manage the scripts they use for their daily work.
2024-07-01
7,013 reads
2024-06-19
392 reads
2024-06-07
358 reads
2024-06-05
430 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...