트랜잭션 로그/NGRAM 함수

트랜잭션로그 정리

https://9618680.blog.me/221115562191

SELECT [name], [recovery_model_desc] FROM sys.databases WHERE [name] = DB_NAME()

ALTER DATABASE SyncAddress SET RECOVERY SIMPLE

     (SELECT 논리적파일이름 = [Name] FROM sys.database_files WHERE type = 1)

DBCC SHRINKFILE('SyncAddress_log', 500000)

ALTER DATABASE SyncAddress SET RECOVERY FULL

NGRAM

USE [SyncAddress]
GO
/****** Object:  UserDefinedFunction [dbo].[FN_PARSE]    Script Date: 2018-07-06 오후 2:05:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:               <Author,,Name>
-- Create date: <Create Date, ,>
-- Description:  <Description, ,>
-- =============================================
ALTER FUNCTION [dbo].[FN_PARSE]
(
        -- Add the parameters for the function here
        @STR NVARCHAR(4000)
)
RETURNS NVARCHAR(MAX)
AS
BEGIN
        -- Declare the return variable here
        DECLARE @RETVAL NVARCHAR(MAX) = ''
        DECLARE @MODSTR NVARCHAR(4000) = REPLACE(@STR, ' ', '')
        -- Add the T-SQL statements to compute the return value here
       

        DECLARE @GRAM INT = 1
        DECLARE @POS INT =  1

        WHILE(@GRAM <= LEN(@MODSTR))
        BEGIN
IF @GRAM > 5 BREAK
                 WHILE(@POS + @GRAM <= LEN(@MODSTR))
                 BEGIN
                         SET @RETVAL += SUBSTRING(@MODSTR, @POS, @GRAM) + ' '
                         SET @POS = @POS + 1             
                 END
                 SET @POS = 1
                 SET @GRAM = @GRAM + 1
        END

        -- Return the result of the function
        RETURN @RETVAL

END