use tempdb;
go
-- Holds numbers 1 to 1 million
create	table [#418BC2CC-48A9-4BCF-9E18-B8FB7BE9D446]
		(
		N	BIGINT PRIMARY KEY CLUSTERED,
		);

-- Generate numbers
with	Numbers (N)
as		(
		select	top (1000000)
				ROW_NUMBER() over (order by (select null))
		from	master.sys.columns C1, master.sys.columns C2, master.sys.columns C3
		)
insert	[#418BC2CC-48A9-4BCF-9E18-B8FB7BE9D446] with (tablockx) (N)
select	N
from	Numbers;
go
-- Test function - just doubles the input
create function dbo.[sfn_7125CD1E-CF5A-4386-B82C-CF52AC756A71] (@number bigint) returns bigint with schemabinding as begin return @number * 2; end;
go
-- Clear ad-hoc sql plans (warning: server-wide, run on test only!)
dbcc freesystemcache(N'SQL Plans');
go
-- Run function one million times - substitute your function here!
declare	@BitBucket BIGINT;
select	@BitBucket = dbo.[sfn_7125CD1E-CF5A-4386-B82C-CF52AC756A71] (N)
from	[#418BC2CC-48A9-4BCF-9E18-B8FB7BE9D446];
go 5
-- Show test results
select	statement_text = SUBSTRING([text], statement_start_offset / 2, (case statement_end_offset when -1 then DATALENGTH(text) else statement_end_offset end) / 2),
		sample_size = execution_count,
		[avg elapsed time µs] = total_elapsed_time / execution_count,
		[avg elapsed time sec] = CONVERT(DEC(9, 3), total_elapsed_time / execution_count / 1000000.0),
		[avg cpu time µs] = total_worker_time / execution_count,
		[avg cpu time sec] = CONVERT(DEC(9, 3), total_worker_time / execution_count / 1000000.0),
		[avg logical reads] = total_logical_reads / execution_count
from	sys.dm_exec_query_stats as qs
cross
apply	sys.dm_exec_sql_text (qs.[sql_handle]) as st
where	st.[text] like '%@BitBucket%[#418BC2CC-48A9-4BCF-9E18-B8FB7BE9D446]%'
and		st.[text] not like '%dm_exec_query_stats%';
go
-- Tidy up
drop table [#418BC2CC-48A9-4BCF-9E18-B8FB7BE9D446];
drop function dbo.[sfn_7125CD1E-CF5A-4386-B82C-CF52AC756A71];
go

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

CREATE TABLE dbo.Numbers (Num INT NOT NULL PRIMARY KEY CLUSTERED);
GO
DECLARE @i INT;
SELECT @i = 1;
WHILE @i <= 10000
BEGIN
    INSERT INTO dbo.Numbers(Num) VALUES (@i);
    SELECT @i = @i + 1;
END;
Create View VwNewId
as
Select New_Id = newid()
go
Drop Function GetRandomCode
go
Create Function GetRandomCode(@CharsNeeded integer)
returns table
as
return
(
with  cteCharsNeeded(Character)
as(
select '1' union all  select '2' union all  select '3' union all  select '4' union all  select '6' union all  select '7' union all  select '8' union all  select '9' union all  Select '0' union all 
select 'A' union all  select 'B' union all  select 'C' union all  select 'D' union all  select 'E' union all  select 'F' union all  select 'G' union all  select 'H' union all  Select 'I' union all 
select 'J' union all  select 'K' union all  select 'L' union all  select 'M' union all  select 'N' union all  select 'O' union all  select 'P' union all  select 'Q' union all  Select 'R' union all 
select 'S' union all  select 'T' union all  select 'U' union all  select 'V' union all  select 'W' union all  select 'X' union all  select 'Y' union all  select 'Z' union all 
select 'a' union all  select 'b' union all  select 'c' union all  select 'd' union all  select 'e' union all  select 'f' union all  select 'g' union all  select 'h' union all  select 'i' union all 
select 'j' union all  select 'k' union all  select 'l' union all  select 'm' union all  select 'n' union all  select 'o' union all  select 'p' union all  select 'q' union all  select 'r' union all 
select 's' union all  select 't' union all  select 'u' union all  select 'v' union all  select 'w' union all  select 'x' union all  select 'y' union all  select 'z'
),
ctenumbers(num)
as
(
   Select Num from numbers
    where Num <= @CharsNeeded
),
cteRandomChars(num,c)
as
(
select num,c = chars.c
 from  ctenumbers cross apply (select top 1 Character from cteCharsNeeded,vwNewId  where num = num order by new_id) as chars(c)
)
select (
select c as [text()] 
 from  cteRandomChars
 for xml path('')) as Random
 
)
go
drop table  #res
go
create table #res
(
random char(8)
)
insert into #res
select  Random from sysobjects cross apply GetRandomCode(case when id is not null then 8 else null end)

CREATE TABLE dbo.Numbers (Num INT NOT NULL PRIMARY KEY CLUSTERED);
GO
DECLARE @i INT;
SELECT @i = 1;
WHILE @i <= 1000
BEGIN
    INSERT INTO dbo.Numbers(Num) VALUES (@i);
    SELECT @i = @i + 1;
END;
go
update statistics Numbers with fullscan
go

drop View VwNewCheck
go
Create View VwNewCheck
as
Select abs(checksum(NewId()))  as New_Id
go




Drop Function GetRandomCode
go

Create Function GetRandomCode(@StrLen integer,@CharsNeeded char(62))
returns table
as
return
(
with cteRandomChars(num,c)
as
(
   Select Num,substring(@CharsNeeded,(Select VwNewCheck.new_id%(len(@CharsNeeded)-1)+1 from VwNewCheck  where num = num ),1)
     from numbers
    where Num <= @StrLen
     
)
select (
select c as [text()] 
 from  cteRandomChars
 for xml path('')) as random
)
go

create table #random
(
random char(8)
)
insert into #random
select  top 15000000 Random from sysobjects cross apply sysobjects so1 cross apply GetRandomCode(case when so1.id is not null or sysobjects.id is not null then 8 else 0 end,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789')
select @@rowcount