# swart (blogs) — RSS Amplifier Recent posts from the 2 feeds in the RSS Amplifier directory that cover swart. Page: Feed: --- ## [Partitioning a Huge Table Quickly](https://michaeljswart.com/2026/08/partitioning-a-huge-table-quickly/) _2026-08-04 · Michael J. Swart · Michael J. Swart_ This is an update to my post last week Partitioning a Huge Table where I talk about taking an existing table and making it partitioned. My largest complaint in that post was that it was difficult to do online because rebuilding a clustered index on a huge table required reading or writing a lot of \[ \] The post Partitioning a Huge Table Quickly first appeared on Michael J. Swart . ## [Partitioning a Huge Table](https://michaeljswart.com/2026/07/partitioning-a-huge-table/) _2026-07-28 · Michael J. Swart · Michael J. Swart_ Aaron Bertrand wants you to consider using partitioned tables and the sliding window pattern to help archive old data. That s a great idea. In fact, I d like to do that at my own job. I have a truly humungous log table (Terabytes) and its clustered index is already on CreatedDate so it s a good candidate \[ \] The post Partitioning a Huge Table first appeared on Michael J. Swart . ## [Adding Foreign Keys Can Cause Deadlock Trouble](https://michaeljswart.com/2026/05/deadlock-trouble/) _2026-05-20 · Michael J. Swart · Michael J. Swart_ Takeaway: Adding foreign keys require schema modification locks on every table involved. This can cause deadlocks on busy systems. Schema modification locks (SCH-M) are taken by DDL (Data Definition Language) statements like CREATE/ALTER/DROP. Schema stability locks (SCH-S) are taken by DML (Data Manipulation Language) statements like INSERT/UPDATE/DELETE. Those two types of locks are… ## [Some tactical advice to my younger self](https://dmswart.com/2026/01/13/some-tactical-advice-to-my-younger-self/) _2026-01-13 · dmswart · D. M. Swart_ Here s some stuff i would say to myself when Cindy and I got married. I.e., when we started our household. The following might seem like I m trying to look like a present day angel. This is pretty far from the truth so let s just call this aspirational .So there s this narrative of the invisible mental load Continue reading Some tactical advice to my younger self ## [Read data from dropped columns](https://michaeljswart.com/2025/01/read-data-from-deleted-columns/) _2025-01-06 · Michael J. Swart · Michael J. Swart_ It s hard to destroy data. Even when a column is dropped, the data is still physically there on the data page. We can use the undocumented/unsupported command DBCC PAGE to look at it. Example First, create a table based on English values from sys.messages: use tempdb; go /\* create table based on english values from \[ \] The post Read data from dropped columns first appeared on Michael J. Swart . ## [Large Uniquifier Values](https://michaeljswart.com/2024/08/large-uniquifier-values/) _2024-08-22 · Michael J. Swart · Michael J. Swart_ Hey what s up? It s been a while. If you define a clustered index that s not unique, SQL Server will add a hidden 4-byte column called UNIQUIFIER. You can t see it directly but it s there. When you add a row whose key is a duplicate of an existing row, the new row gets a new unique \[ \] The post Large Uniquifier Values first appeared on Michael J. Swart .