ERROR, Sql Server - rextester

ERROR

Language: Layout:

CREATE TABLE [dbo].[Table1](
	[id]  uniqueidentifier NOT NULL ,
	[id2] uniqueidentifier NOT NULL,
	[name] nvarchar(max) NOT NULL
 CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
))
GO
CREATE NONCLUSTERED INDEX [IX_Table2_ID2] ON [dbo].[Table1]
(
	[id2] ASC
)
ALTER TABLE [dbo].[Table1] ADD  CONSTRAINT [DF_Id]  DEFAULT (newsequentialid()) FOR [id]

GO
CREATE TABLE [dbo].[Table2](
	[id] uniqueidentifier NOT NULL,
	[name] varchar(10)
 CONSTRAINT [PK_Table2] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)) 
GO
ALTER TABLE [dbo].[Table2] ADD  CONSTRAINT [DF_Id2]  DEFAULT (newsequentialid()) FOR [id]

Declare @loop int = 1
while @loop<=10
	begin
	insert into Table2 ([name]) Values(char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65)))
	set @loop = @loop+1
	end
set @loop = 1
while @loop<2000
	begin
	insert into Table1 (ID2, [name])
    select ID,char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65)) from Table2
	set @loop = @loop+1
	end
select top 100 table1.Name,table2.Name 
from table1 WITH (NOLOCK) left join table2 on table1.ID2= table2.ID 
order by table2.ID desc,table1.ID desc

View schema
Execution time: 0,55 sec, rows selected: 2111, rows affected: 20000, absolute service time: 0,95 sec

	Name	Name
1	BCEM	YAWM
2	QNRD	YAWM
3	KLKM	YAWM
4	BURF	YAWM
5	MRUL	YAWM
6	SWRF	YAWM
7	VMJX	YAWM
8	PLRT	YAWM
9	WUYU	YAWM
10	NKON	YAWM
11	IGCN	YAWM
12	GVCC	YAWM
13	UGAT	YAWM
14	RAIX	YAWM
15	PNIW	YAWM
16	KOMX	YAWM
17	WUFT	YAWM
18	TSTV	YAWM
19	UDPA	YAWM
20	FLIY	YAWM
21	QGRD	YAWM
22	JICM	YAWM
23	SMNI	YAWM
24	ORMN	YAWM
25	WJHY	YAWM
26	ETGO	YAWM
27	UJXP	YAWM
28	AMDN	YAWM
29	IQDV	YAWM
30	EPJS	YAWM
31	ELRR	YAWM
32	MKND	YAWM
33	WNYG	YAWM
34	LALH	YAWM
35	PHVQ	YAWM
36	FUBJ	YAWM
37	YLDB	YAWM
38	BCWF	YAWM
39	KYFN	YAWM
40	DXYP	YAWM
41	ORPB	YAWM
42	PNVI	YAWM
43	VXTS	YAWM
44	URCS	YAWM
45	BWDS	YAWM
46	YEBN	YAWM
47	IXJM	YAWM
48	VUBY	YAWM
49	SLML	YAWM
50	GDYN	YAWM
51	JMMG	YAWM
52	RXWU	YAWM
53	EKMM	YAWM
54	QUKX	YAWM
55	MTJV	YAWM
56	NKIY	YAWM
57	SSOG	YAWM
58	GOMH	YAWM
59	AFGW	YAWM
60	WBWN	YAWM
61	EATO	YAWM
62	QUEA	YAWM
63	HQFB	YAWM
64	GCML	YAWM
65	KSRK	YAWM
66	CHXH	YAWM
67	WWMW	YAWM
68	PRPY	YAWM
69	VEHW	YAWM
70	FJYJ	YAWM
71	VRUO	YAWM
72	MTML	YAWM
73	RIVG	YAWM
74	VLRL	YAWM
75	BDTQ	YAWM
76	BJVC	YAWM
77	TKHO	YAWM
78	CPCT	YAWM
79	XTKU	YAWM
80	GWFQ	YAWM
81	FQLI	YAWM
82	FBJV	YAWM
83	SEQL	YAWM
84	VJSJ	YAWM
85	YUME	YAWM
86	XOTT	YAWM
87	VUPF	YAWM
88	QOQJ	YAWM
89	PBQD	YAWM
90	WDFG	YAWM
91	SCGD	YAWM
92	SQUR	YAWM
93	CRIX	YAWM
94	JHVV	YAWM
95	YSMB	YAWM
96	ECUQ	YAWM
97	FMHX	YAWM
98	HKGP	YAWM
99	DHBF	YAWM
100	IWBA	YAWM