declare @n int, @D datetime

create table #tab1
	(
	RowID int identity,
	Field1 datetime,
	Field2 varchar( 100 )
	)

select @n= 1 , @D=getdate()

while @n< 100000 
begin
	insert into #tab1 (Field1, Field2)
	values ('2002.10.16', 'qwertyuiop[];lkjhgfdsazxcvbnm,./qwertyuiop[];lkjhgfdsazxcvbnm,./')
	set @n=@n+ 1 
end

select datediff(ms, @D, getdate())

drop table #tab1

 1 . tempdb на RAM
 28010 ,  27940 ,  27640 

 2 . Все то же - только с обычной таблицей (tab1)
 75696 ,  75346 ,  75676 

declare @n int, @D datetime,  @D_total datetime, @S varchar( 64 )

create table tab1
	(
	RowID int identity,
	Field1 float,
	Field2 varchar( 64 )
	)

create table tab2
	(
	RowID int identity,
	Field1 float,
	Field2 varchar( 64 )
	)

set nocount on

select @n= 1 , @D=getdate(), @D_total=getdate(), @S='qwertyuiop[];lkjhgfdsazxcvbnm,./qwertyuiop[];lkjhgfdsazxcvbnm,./'

while @n< 100000 
begin
	insert into tab1 (Field1, Field2)
	values (sin(@n), @S)
	set @n=@n+ 1 
end
create index tab1_ind1 on tab1 (Field1)

select datediff(ms, @D, getdate())
set @D=getdate()

while @n> 1 
begin
	insert into tab2 (Field1, Field2)
	values (sin(@n), @S)
	set @n=@n- 2 
end
create index tab2_ind1 on tab2 (Field1)

select datediff(ms, @D, getdate())
set @D=getdate()

update tab2 set Field2='1234567890123456789012345678901234567890'
where (cast(RowID as numeric( 15 , 3 ))/ 2 -round(cast(RowID as numeric( 15 , 3 ))/ 2 , 0 ))= 0  and Field1> 0 . 2 

drop index tab1.tab1_ind1
drop index tab2.tab2_ind1

create index tab1_ind1 on tab1 (Field1)
create index tab2_ind1 on tab2 (Field1)

select *
from tab1 t1 inner join
	tab2 t2 on t1.Field1=t2.Field1
where t2.Field1 between  0 . 5  and  0 . 7 
order by t1.Field1

select datediff(ms, @D, getdate()), datediff(ms, @D_total, getdate())

drop table tab1
drop table tab2

 1 . #temptables
 7163 ;  3543 ;  1903 , 12610 
 2 . tables
 46116 ;  22050 ;  2243 ,  70410 

Phisical Memory(K)
Total  522544 
Available  52248 
System Cache  118244 

Process sqlserver.exe  155570  K