Msg 3701, Level 11, State 3:
Line 2:
Cannot drop the index 'Emp10.my_index', because it doesn't exist in the system
catalogs.
(2000 rows affected)
--------------------- Doing for 0010 without index

Starting copy...

50 rows copied.
Clock Time (ms.): total = 1      Avg = 0      (50000.00 rows per sec.)
(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 UNION] Elapsed Time 50                   milliseconds
--------------------- Doing for 0010 with index
(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 UNION] Elapsed Time 53                   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.)
(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 UNION] Elapsed Time 136                  milliseconds
---------------------- Doing for 0020 with index
(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 UNION] Elapsed Time 136                  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.)
(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 UNION] Elapsed Time 403                  milliseconds
----------------------- Doing for 0040 with index
(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 UNION] Elapsed Time 200                  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.)
(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 UNION] Elapsed Time 2026                 milliseconds
----------------------- Doing for 0100 with index
(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 UNION] Elapsed Time 513                  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.)
(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 UNION] Elapsed Time 1083                 milliseconds
----------------------- Doing for 0200 with index
(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 UNION] Elapsed Time 1020                 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.)
(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 UNION] Elapsed Time 2390                 milliseconds
----------------------- Doing for 0400 with index
(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 UNION] Elapsed Time 2213                 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 = 1000   Avg = 0      (5000.00 rows per sec.)
(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 UNION] Elapsed Time 6826                 milliseconds
----------------------- Doing for 1000 with index
(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 UNION] Elapsed Time 6140                 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 = 4000   Avg = 0      (3880.50 rows per sec.)
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 15522               
(1 row affected)
Start
Msg 1105, Level 17, State 2:
Line 21:
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 21:
Sort failed: Out of space in database 'tempdb'
----------------------- Doing for 2000 with index
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 15522               
(1 row affected)
Start
(1701 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 1701                
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNION] Elapsed Time 20163                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 = 6000   Avg = 0      (3975.17 rows per sec.)
(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 21:
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 21:
Sort failed: Out of space in database 'tempdb'
----------------------- Doing for 4000 with index
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 23851               
(1 row affected)
Start
(3420 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 3420                
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNION] Elapsed Time 28160                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.)
(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 21:
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
(1 row affected)
(1 row affected)
(1 row affected)
# of Records to Operate on : 57994               
(1 row affected)
Start
(8277 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
Resulting Records : 8277                
(1 row affected)
(1 row affected)
[Emp10 TJOIN UNION] Elapsed Time 69533                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 = 27000  Avg = 0      (3703.70 rows per sec.)
(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 21:
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
(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 UNION] Elapsed Time 123236               milliseconds
