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)
4,147 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,147 reads
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,200 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,184 reads
Learn how you can use AutomatedLab to quickly create new environments.
2023-08-04
2,696 reads
This article delves into five new dbatools command that work with sequence objects.
2023-05-31
1,487 reads
We cannot import multiple packages on the SSIS server. So, loading 100 packageS from file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]
2021-09-27 (first published: 2021-09-22)
1,772 reads
create a sql server polybase scale out group in azure for free
2021-06-23 (first published: 2021-04-12)
1,895 reads
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2020-11-24
48,678 reads
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
2020-11-10
4,032 reads
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
2,084 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers