CREATE PROCEDURE SLOW$LIKE_Int_JOIN_test @str nvarchar(MAX), @tookms int OUTPUT AS DECLARE @start datetime SELECT @start = getdate() INSERT Int_JOIN(word) SELECT u.word FROM usrdictwords u WHERE ',' + @str COLLATE Slovenian_BIN2 + ',' LIKE '%,' COLLATE Slovenian_BIN2 + ltrim(str(wordno)) + ',%' SELECT @tookms = datediff(ms, @start, getdate()); SELECT word FROM Int_JOIN TRUNCATE TABLE Int_JOIN go CREATE PROCEDURE SLOW$LIKE_Str_JOIN_test @str nvarchar(MAX), @tookms int OUTPUT AS DECLARE @start datetime SELECT @start = getdate() INSERT Str_JOIN(wordno, guid) SELECT u.wordno, u.guid FROM usrdictwords u WHERE ',' + @str + ',' LIKE '%,' + u.word + ',%' SELECT @tookms = datediff(ms, @start, getdate()); SELECT wordno FROM Str_JOIN TRUNCATE TABLE Str_JOIN go