We walk in the dark places no others will enter
We stand on the bridge and no one may pass

USE AdventureWorks
GO
IF OBJECT_ID('TheTable') IS NOT NULL
BEGIN
	DROP TABLE TheTable;
END
GO
CREATE TABLE TheTable
(
ID INT IDENTITY(1,1),
Data VARCHAR(2000) 
)
GO
INSERT INTO TheTable (Data) VALUES (REPLICATE('SomeData',150)) 
GO 1000
GO
--Check the number of pages allocated to the table
GO
DBCC IND ('AdventureWorks','TheTable',-1) -- 175 pages
GO
DELETE FROM TheTable WITH (TABLOCK) 
GO
DBCC IND ('AdventureWorks','TheTable',-1) -- Only 1 page (IAM page) available & all other pages deallocated 
											--after deleting with TABLOCK