ALTER DATABASE [DBNAME] SET DELAYED_DURABILITY = FORCED;
https://msdn.microsoft.com/en-us/library/dn449490.aspx
CREATE PROCEDURE <procedureName> …
WITH NATIVE_COMPILATION, SCHEMABINDING, EXECUTE AS OWNER
AS BEGIN ATOMIC WITH
(
DELAYED_DURABILITY = ON,
TRANSACTION ISOLATION LEVEL = SNAPSHOT,
LANGUAGE = N'English'
{YOUR T-SQL IMPLEMENTATION HERE}
)
END