This topic describes how to use [!INCLUDE[tsql](../../includes/tsql-md.md)] to verify that a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database file ...
I was assuming that if you are writing at 4 points in the file then you'll be making 4 fragments, but it seems I was wrong about that! Yeah, not on Windows, unless you're dealing with sparse files.
Ok, this is one for the real MacOS experts. What I want to do is reclaim unused disk blocks from an SQLite file and free those so they can be used for something else. sqlite_sparse on Github does ...