SQL Server does not reclaim space used when inserts fail

(Matteo Lorini) SQL Server has an issue when an INSERT fails that includes LOB data, SQL Server allocates space for the insert but does not reclaim the space on the failure therefore taking up more space than necessary. In this tip I walk through an example of this issue and ways to resolve it.

Read More - Register for Free Membership