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,457 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)
3,457 reads
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,105 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
1,992 reads
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
413 reads
This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.
2023-10-06
1,488 reads
If you have ever played a game of chess against someone good, or perhaps against a computer, you know that a good player is always thinking multiple moves ahead. Being a DBA and/or a database programmer is like playing several chess games simultaneously.
2023-07-19
It seems like every DBA has a USB stick or a shared drive filled with scripts they can pull up in almost any situation. How can I build such a library of T-SQL files?
2023-06-26
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
2022-03-04
3,573 reads
Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here!
2022-01-17
Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.
2021-12-29
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
I'm not sure that I'm posting this in the right section, so please mods...
Hi all I've written a script to keep track of how long backups...
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers