Создание временной таблицы - SQL Server - Ответ 4066033

if OBJECT_ID('tempdb..#msg','U') is not null drop table #msg
create table #msg (
    message_id int, language_id smallint, severity tinyint, is_event_logged bit, 
    text nvarchar(100), hash_text as checksum(text) persisted,
    primary key(message_id,language_id))
create index #msg_hash on #msg (hash_text)
create index #msg_text on #msg (text)
 
insert into #msg
SELECT m.message_id, m.language_id, m.severity, m.is_event_logged, left(m.text,100)--, CHECKSUM(left(m.text,100))
    FROM sys.messages m --where m.language_id in (1049, 1033,1031)
 
declare @msg table (
    message_id int, language_id smallint, severity tinyint, is_event_logged bit, 
    text nvarchar(100), hash_text as checksum(text) persisted,
    primary key(message_id,language_id,text))
insert @msg select message_id, language_id, severity, is_event_logged, text  from #msg
--select * from #msg order by len(text)
 
declare @timing table(id int /*identity*/, timer datetime)
insert @timing values (1,getdate())
SELECT * FROM @msg where hash_text=CHECKSUM('уведомление') and text = 'уведомление'
insert @timing values (2,getdate())
SELECT * FROM #msg where hash_text=CHECKSUM('уведомление') and text = 'уведомление'
insert @timing values (3,getdate())
SELECT * FROM @msg where text like '%уведомление%'
insert @timing values (4,getdate())
SELECT * FROM #msg where text like '%уведомление%'
insert @timing values (5,getdate())
SELECT * FROM @msg where text = 'уведомление'
insert @timing values (6,getdate())
SELECT * FROM #msg where text = 'уведомление'
insert @timing values (7,getdate())
SELECT * FROM @msg where message_id=14210 and language_id=1049
insert @timing values (8,getdate())
SELECT * FROM #msg where message_id=14210 and language_id=1049
insert @timing values (9,getdate())
;with delta as (
    select t.id, t.timer start, n.timer stop, DATEDIFF(mcs,t.timer,n.timer) delta
        from @timing t
        join @timing n on n.id=t.id+1
    )
select *, [as#].delta-[as@].delta [#-@]
    from delta [as@] 
    join delta [as#] on [as#].id=[as@].id+1
    where [as@].id%2=1