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