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
1,571 reads
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-04-26
1,571 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,332 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
2,893 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
DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.
2021-06-07
In this article we discuss deploying SQL Server containers / images using Azure Kubernetes Cluster.
2021-04-01
DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job.
2021-03-12
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers