Difference between Sql server 2000 and 2005
SlNo.
|
Sql-2000
|
Sql-2005
|
1
|
Query analyser and Enterprise were separate
|
Both were combined as SSMS(Sql Server Management Studio)
|
2
|
There was No XML data type
|
XML data type introduced
|
3
|
There was no Exception handling
|
Exception handing introduced
|
4
|
We can’t encrypt database
|
We can encrypt database
|
5
|
PIVOT and UNPIVOT functions were not provided.
|
PIVOT and UNPIVOT functions were
introduced.
|
Difference between Sql server 2005 and 2008
SlNo.
|
Sql-2005
|
Sql-2008
|
1
|
Merge statement is not there
|
Merge statement is introduced
|
2
|
DateTime is used
for both date and time
|
DateTime separated into four types- Date, Time,
DateTimeOffSet and DateTime2.
|
3
|
Table-valued parameter is not there
|
Table-valued parameter is introduced
|
4
|
LINQ is not there
|
LINQ introduced
|
5
|
Back-up encrypt is not there
|
Back-up encrypt is provided
|
Difference between Sql server 2008 and 2008 R2
SlNo.
|
Sql-2008
|
Sql-2008 R2
|
1
|
Its support maximum 64 logical process
|
Its support maximum 256 logical process
|
2
|
Master Data Services not provided
|
Master Data Services provided
|
3
|
Introduced
goespatail data type with few comman features in ssrs2008
|
Introduced goespatail data type with few comman
features in ssrs2008 R2 including mapping, routing and custom shapes.
|
Difference between Sql server 2008 and 2012
SlNo.
|
Sql-2008
|
Sql-2012
|
1
|
Query page spliting is not there in sql-2008.
|
Query page spliting is implemented in sql-2012.
|
2
|
String functions
CONCATE and FORMAT are not available.
|
String functions CONCATE and FORMAT are
available.
|
3
|
Its support only 1000 partitions.
|
Its support only 15000 partitions.
|
4
|
Analysis services in Sql server does not have BI
semantic model (BISM) concept.
|
Analysis services will include a
new BI semantic model (BISM) concept. BISM is 3 layer model that’s include
1.Data Model
2.Business Logics
3.Data Access layer.
|
5
|
The Sql Server 2008 uses 27 bit precision for spatial data type.
|
The Sql Server 2008 uses 48 bit precision for spatial data type.
|
In this above post I explained differences among Sql server versions. I hpe you enjoyed it so please send your feedback and queries. Thnak You.
No comments:
Post a Comment