Enterprise

KEY:

= Full

= Partial/Limited

= Not Available

	SQL Server 2008 Enterprise Edition	SQL Server 2008 Standard Edition
Number of CPUs	OS Maximum	4
Scalability & Performance
High Availability (Always On)
Enterprise Security
Data Warehousing
Business Intelligence
Enterprise Manageability

Review the detailed feature comparison.

Source link:  http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx

———————————————————————-
– Carlos Galhano 2009.02.05
– Duplicação de Registos indexados
–tab teste: testeid,titulo
–tab teste2: teste2id,titulo2,testeid
———————————————————————-
Alter table teste add oldid integer
———————————————————————-
Select TesteID, Titulo INTO #tmpteste FROM teste
go
insert into teste (Titulo,oldid) (Select Titulo,testeid from #tmpteste)
go

—————–
Select teste.TesteID, teste2.Titulo2 INTO #tmpteste2 FROM teste2 inner join teste on teste.oldid=teste2.testeid
go
—————–
insert into teste2 (Titulo2,testeID)
((Select  Titulo2,testeid from #tmpteste2  ))
go
—————–
drop table #tmpteste
go
drop table #tmpteste2
go
—————–
Alter table teste drop column oldid
———————————————————————-