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,664 reads
SQL Server internal storage
Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,053 reads
2024-04-10
425 reads
Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation
Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]
2021-05-10
7,025 reads
Understanding CRUD Operations Against Heaps and Forwarding Pointers
In this article, we examine how data changes are made against heaps.
2021-05-03
4,411 reads
Understanding the Internals of a Data Page
In Part 1 of this series, we examine the structure of data pages and how your tables are stored on these pages.
2021-04-13
16,082 reads
2020-06-26
632 reads
Transaction Log Structure
Intro This post shows the internal logical structure of the SQL Server Transaction Log. The details here target SQL Server 2000 to 2017. Note that SQL Server 2019 will...
2019-04-12
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,761 reads
Blogs
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Forums
How to speed up this query?
Hi everyone I have a query that is taking a real long time. It...
The New Log File
Comments posted to this topic are about the item The New Log File
Getting Started with the Data API Builder
Comments posted to this topic are about the item Getting Started with the Data...
Question of the Day
The New Log File
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers