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
2,329 reads
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-04-26
2,329 reads
2024-04-10
394 reads
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
6,295 reads
In this article, we examine how data changes are made against heaps.
2021-05-03
4,173 reads
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
13,178 reads
2020-06-26
629 reads
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
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,625 reads
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers