Trancate table and LOB data

sakuraime 2,276 Reputation points
2020-08-28T02:54:57.383+00:00

where there are still LOB allocation unit after the table is truncated ?
21055-truncate.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,571 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. tibor_karaszi@hotmail.com 4,291 Reputation points Microsoft MVP
    2020-08-28T06:42:23.613+00:00

    The deallocation of storage is a deferred operation. It runs after you commit, in batches. See this: https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms177495(v=sql.105)?redirectedfrom=MSDN

    No comments

  2. Miamiao-MSFT 4,216 Reputation points
    2020-08-28T07:39:21.687+00:00

    Hi @sakuraime ,

    why there are still LOB allocation unit after the table is truncated ?

    No truncate on my side.
    Could you please execute refresh after your execute the first query and then execute the second query?
    And what is your script of your table “TableMetaData”?

    21191-20200828truncate.jpg

    BR,
    Mia
    If the reply is helped, please do “Accept Answer”.--Mia