2025-01-15
1,833 reads
2025-01-15
1,833 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,883 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,107 reads
2024-04-10
431 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
7,209 reads
In this article, we examine how data changes are made against heaps.
2021-05-03
4,462 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
16,701 reads
2020-06-26
634 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,794 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Hi, I am using the SSMA for Oracle v10.0. I have installed the SSMA...
Hi, I an using VS 2022 to build a package that selects and then...
Accidental DBA here. After looking at all the work that needs to be done,...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers