sql server exact string match

gistfile1.txt

DECLARE @nrRows INT;
SET @nrRows=1000000;

--drop table if exists tmp;
create table tmp
(
	idString varchar(36)
);

WITH guidRows ( n ) AS (
		SELECT 1 UNION ALL
		SELECT 1 + n FROM guidRows WHERE n < @nrRows )
insert into tmp 
select
	convert(varchar(36), NEWID()) as idString
FROM
	guidRows
OPTION ( MAXRECURSION 0 )

SET STATISTICS XML ON; 

select * from tmp where idString = 'kalleanka'

SET STATISTICS XML OFF;