Clean and shrink SQL database

DeleteInBatches.sql

SET NOCOUNT ON;
 
DECLARE @rows int = 1;
DECLARE @now datetime = GETDATE();
 
WHILE @rows > 0
BEGIN
  BEGIN TRANSACTION;
 
    DELETE TOP (500) [ASPState].dbo.ASPStateTempSessions
    WHERE Expires < @now
 
    SET @rows = @@ROWCOUNT;
 
  COMMIT TRANSACTION;
 
  CHECKPOINT;
END

-- https://ignas.me/tech/clean-and-shrink-sql-database/

ShrinkDatabaseFile.sql

ALTER DATABASE ASPState SET RECOVERY SIMPLE
DBCC SHRINKFILE (ASPState_Log, 1)

-- https://ignas.me/tech/clean-and-shrink-sql-database/