Change, Sql Server

Change

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]

CREATE NONCLUSTERED INDEX [ndx_name] ON [dbo].[Table2]
(
	[name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
GO

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

select top 100 table1.Name,table2.Name 
from table1 WITH (NOLOCK) left join table2 on table1.ID2= table2.ID 
order by table2.name desc,table1.ID desc

View schema
Execution time: 0,62 sec, rows selected: 2211, rows affected: 20000, absolute service time: 1,08 sec

	Name	Name
1	HAAD	VKQU
2	VBPL	VKQU
3	RXHD	VKQU
4	OJJO	VKQU
5	GMCM	VKQU
6	RGYB	VKQU
7	JAHG	VKQU
8	ORTN	VKQU
9	NWLK	VKQU
10	DBKK	VKQU
11	LNJA	VKQU
12	QMXC	VKQU
13	BVQX	VKQU
14	TTAC	VKQU
15	HHLV	VKQU
16	HXSE	VKQU
17	VWSM	VKQU
18	KAYY	VKQU
19	NKJA	VKQU
20	LANY	VKQU
21	HLKY	VKQU
22	NQWM	VKQU
23	SILH	VKQU
24	HFDR	VKQU
25	PJCH	VKQU
26	HMFQ	VKQU
27	OSHL	VKQU
28	JMCQ	VKQU
29	VSFH	VKQU
30	QCBY	VKQU
31	CGMP	VKQU
32	ULDC	VKQU
33	KGQV	VKQU
34	MOWS	VKQU
35	DFUG	VKQU
36	HYHK	VKQU
37	WOMG	VKQU
38	VNRR	VKQU
39	MHFL	VKQU
40	TEVY	VKQU
41	IFKO	VKQU
42	UWFK	VKQU
43	LPLU	VKQU
44	QLBU	VKQU
45	WFGI	VKQU
46	TEDU	VKQU
47	JJDR	VKQU
48	AWTC	VKQU
49	XNKH	VKQU
50	PIWH	VKQU
51	ILVN	VKQU
52	MOBC	VKQU
53	SRMK	VKQU
54	XAMH	VKQU
55	DMIC	VKQU
56	QTHF	VKQU
57	JYPV	VKQU
58	QNBE	VKQU
59	HSIR	VKQU
60	EPYL	VKQU
61	DCGX	VKQU
62	ORBX	VKQU
63	VKWR	VKQU
64	APHW	VKQU
65	EVVM	VKQU
66	QULX	VKQU
67	BOMY	VKQU
68	FHYI	VKQU
69	WEFI	VKQU
70	KPLL	VKQU
71	VRJL	VKQU
72	RLTB	VKQU
73	WNQN	VKQU
74	SCQE	VKQU
75	KVLK	VKQU
76	AETN	VKQU
77	XFHA	VKQU
78	JCRD	VKQU
79	TWGM	VKQU
80	DVIQ	VKQU
81	VYFT	VKQU
82	WUEU	VKQU
83	TROK	VKQU
84	IFHB	VKQU
85	AOKV	VKQU
86	TNRQ	VKQU
87	SEHJ	VKQU
88	BKRK	VKQU
89	LECS	VKQU
90	MUSS	VKQU
91	VGSH	VKQU
92	RNHS	VKQU
93	AWGV	VKQU
94	LBKC	VKQU
95	IBES	VKQU
96	FKIL	VKQU
97	MDSK	VKQU
98	PKSA	VKQU
99	KTHQ	VKQU
100	WIHL	VKQU

	Name	Name
1	HAAD	VNFJ
2	VBPL	VNFJ
3	RXHD	VNFJ
4	OJJO	VNFJ
5	GMCM	VNFJ
6	RGYB	VNFJ
7	JAHG	VNFJ
8	ORTN	VNFJ
9	NWLK	VNFJ
10	DBKK	VNFJ
11	LNJA	VNFJ
12	QMXC	VNFJ
13	BVQX	VNFJ
14	TTAC	VNFJ
15	HHLV	VNFJ
16	HXSE	VNFJ
17	VWSM	VNFJ
18	KAYY	VNFJ
19	NKJA	VNFJ
20	LANY	VNFJ
21	HLKY	VNFJ
22	NQWM	VNFJ
23	SILH	VNFJ
24	HFDR	VNFJ
25	PJCH	VNFJ
26	HMFQ	VNFJ
27	OSHL	VNFJ
28	JMCQ	VNFJ
29	VSFH	VNFJ
30	QCBY	VNFJ
31	CGMP	VNFJ
32	ULDC	VNFJ
33	KGQV	VNFJ
34	MOWS	VNFJ
35	DFUG	VNFJ
36	HYHK	VNFJ
37	WOMG	VNFJ
38	VNRR	VNFJ
39	MHFL	VNFJ
40	TEVY	VNFJ
41	IFKO	VNFJ
42	UWFK	VNFJ
43	LPLU	VNFJ
44	QLBU	VNFJ
45	WFGI	VNFJ
46	TEDU	VNFJ
47	JJDR	VNFJ
48	AWTC	VNFJ
49	XNKH	VNFJ
50	PIWH	VNFJ
51	ILVN	VNFJ
52	MOBC	VNFJ
53	SRMK	VNFJ
54	XAMH	VNFJ
55	DMIC	VNFJ
56	QTHF	VNFJ
57	JYPV	VNFJ
58	QNBE	VNFJ
59	HSIR	VNFJ
60	EPYL	VNFJ
61	DCGX	VNFJ
62	ORBX	VNFJ
63	VKWR	VNFJ
64	APHW	VNFJ
65	EVVM	VNFJ
66	QULX	VNFJ
67	BOMY	VNFJ
68	FHYI	VNFJ
69	WEFI	VNFJ
70	KPLL	VNFJ
71	VRJL	VNFJ
72	RLTB	VNFJ
73	WNQN	VNFJ
74	SCQE	VNFJ
75	KVLK	VNFJ
76	AETN	VNFJ
77	XFHA	VNFJ
78	JCRD	VNFJ
79	TWGM	VNFJ
80	DVIQ	VNFJ
81	VYFT	VNFJ
82	WUEU	VNFJ
83	TROK	VNFJ
84	IFHB	VNFJ
85	AOKV	VNFJ
86	TNRQ	VNFJ
87	SEHJ	VNFJ
88	BKRK	VNFJ
89	LECS	VNFJ
90	MUSS	VNFJ
91	VGSH	VNFJ
92	RNHS	VNFJ
93	AWGV	VNFJ
94	LBKC	VNFJ
95	IBES	VNFJ
96	FKIL	VNFJ
97	MDSK	VNFJ
98	PKSA	VNFJ
99	KTHQ	VNFJ
100	WIHL	VNFJ