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,904 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,904 reads
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,165 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,114 reads
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
419 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,653 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,877 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
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Hello, I ran below statements in MS SQL, and got error, but fine in...
I am a software developer using MS SQL server as my database. I have...
Comments posted to this topic are about the item Limits, Not Goals
What is the precision, length, and scale for an int variable?
See possible answers