Today I needed to perform following command prior to deleting a file of TEMPDB:
DBCC SHRINKFILE (N’tempdev02′ , EMPTYFILE)
But received following error:
DBCC SHRINKFILE: Page could not be moved because it is a work table page.
Apparantly, in most cases work tables are related to Query Plans. So running following DBCC solved my problem:
Thanks to Mike Rose