The below are the basic differences between SQL 08 and SQL 08 R2.
1.In SQL 2008 maximum logical processor support is 64 where as in SQL 2008 R2 maximum logical processor support is 256.
2.In SQL 2008 Master Data Services (MDS) are not part of BI where as in SQL 2008 R2 MDS is part of BI.
3.In SQL 2008 Power Pivot with in BI is not implemented where as in SQL 2008 R2 Power Pivot in BI is implemented.
4.In SQL 2008 geo spatial data type is introduced with few common features for SSRS where as in SQL 2008 R 2 additional features are added to geo spatial data types in SSRS such as mapping , routing and custom shapes.
5.In SQL 2008 maximum size of a database is 4 gb in express editions where as in SQL 2008 R2 database size limited is increase to 10 gb in express edition .
1.In SQL 2008 maximum logical processor support is 64 where as in SQL 2008 R2 maximum logical processor support is 256.
2.In SQL 2008 Master Data Services (MDS) are not part of BI where as in SQL 2008 R2 MDS is part of BI.
3.In SQL 2008 Power Pivot with in BI is not implemented where as in SQL 2008 R2 Power Pivot in BI is implemented.
4.In SQL 2008 geo spatial data type is introduced with few common features for SSRS where as in SQL 2008 R 2 additional features are added to geo spatial data types in SSRS such as mapping , routing and custom shapes.
5.In SQL 2008 maximum size of a database is 4 gb in express editions where as in SQL 2008 R2 database size limited is increase to 10 gb in express edition .
No comments:
Post a Comment