(100000 rows affected)
--------------------- Doing for 0010 without index

Starting copy...

50 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (50000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 50                  
(1 row affected)
Start
(9 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 9                   
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 53                   milliseconds
--------------------- Doing for 0010 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 50                  
(1 row affected)
Start
(9 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 9                   
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 50                   milliseconds
(50 rows affected)
--------------------- Doing for 0020 without index

Starting copy...

100 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (100000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 100                 
(1 row affected)
Start
(23 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 23                  
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 140                  milliseconds
---------------------- Doing for 0020 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 100                 
(1 row affected)
Start
(23 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 23                  
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 140                  milliseconds
(100 rows affected)
----------------------- Doing for 0040 without index

Starting copy...

200 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (200000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 200                 
(1 row affected)
Start
(34 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 34                  
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 406                  milliseconds
----------------------- Doing for 0040 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 200                 
(1 row affected)
Start
(34 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 34                  
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 206                  milliseconds
(200 rows affected)
----------------------- Doing for 0100 without index

Starting copy...

500 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (500000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 500                 
(1 row affected)
Start
(97 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 97                  
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 2030                 milliseconds
----------------------- Doing for 0100 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 500                 
(1 row affected)
Start
(97 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 97                  
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 546                  milliseconds
(500 rows affected)
----------------------- Doing for 0200 without index

Starting copy...
1000 rows sent to SQL Server.

1000 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (1000000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 1000                
(1 row affected)
Start
(162 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 162                 
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 1486                 milliseconds
----------------------- Doing for 0200 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 1000                
(1 row affected)
Start
(162 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 162                 
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 1073                 milliseconds
(1000 rows affected)
----------------------- Doing for 0400 without index

Starting copy...
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.

2000 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (2000000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 2000                
(1 row affected)
Start
(304 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 304                 
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 2196                 milliseconds
----------------------- Doing for 0400 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 2000                
(1 row affected)
Start
(304 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 304                 
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 2376                 milliseconds
(2000 rows affected)
----------------------- Doing for 1000 without index

Starting copy...
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.

5000 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (5000000.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 5000                
(1 row affected)
Start
(865 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 865                 
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 6470                 milliseconds
----------------------- Doing for 1000 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 5000                
(1 row affected)
Start
(865 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 865                 
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 5830                 milliseconds
(5000 rows affected)
----------------------- Doing for 2000 without index

Starting copy...
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.

15522 rows copied.
Clock Time (ms.): total = 3000   Avg = 0      (5174.00 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 15522               
(1 row affected)
Start
(4606 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 4606                
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 21720                milliseconds
----------------------- Doing for 2000 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 15522               
(1 row affected)
Start
(4606 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 4606                
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 20896                milliseconds
(15522 rows affected)
----------------------- Doing for 4000 without index

Starting copy...
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.

23851 rows copied.
Clock Time (ms.): total = 5000   Avg = 0      (4770.20 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 23851               
(1 row affected)
Start
Msg 1105, Level 17, State 2:
Line 23:
Can't allocate space for object 'temp worktable' in database 'tempdb' because
the 'system' segment is full. If you ran out of space in syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase
the size of the segment.
Msg 1510, Level 17, State 4:
Line 23:
Sort failed: Out of space in database 'tempdb'
----------------------- Doing for 4000 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 23851               
(1 row affected)
Start
(4946 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 4946                
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 28913                milliseconds
(23851 rows affected)
----------------------- Doing for 10000 without index

Starting copy...
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.

57994 rows copied.
Clock Time (ms.): total = 15000  Avg = 0      (3866.27 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 57994               
(1 row affected)
Start
Msg 1105, Level 17, State 1:
Line 23:
Can't allocate space for object 'temp worktable' in database 'tempdb' because
the 'system' segment is full. If you ran out of space in syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase
the size of the segment.
----------------------- Doing for 10000 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 57994               
(1 row affected)
Start
(10936 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 10936               
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 70106                milliseconds
(57994 rows affected)
----------------------- Doing for 20000 without index

Starting copy...
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.
1000 rows sent to SQL Server.

100000 rows copied.
Clock Time (ms.): total = 26000  Avg = 0      (3846.15 rows per sec.)
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 100000              
(1 row affected)
Start
Msg 1105, Level 17, State 1:
Line 23:
Can't allocate space for object 'temp worktable' in database 'tempdb' because
the 'system' segment is full. If you ran out of space in syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase
the size of the segment.
----------------------- Doing for 20000 with index
 EID         StartDate                  EndDate                    
 ----------- -------------------------- -------------------------- 

(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 100000              
(1 row affected)
Start
(16681 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 16681               
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNIONALL] Elapsed Time 139950               milliseconds
