Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Differences between sql server 2008 and 2008 R2 Expand / Collapse
Author
Message
Posted Sunday, November 28, 2010 9:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 28, 2010 9:06 PM
Points: 1, Visits: 0
I think that major difference is the size of database support from my point of view and I also think that SQL Server 2008 R2 does not work in XP Home systems.
The largest database supported by SQL Server Express has been increased from 4 GB to 10 GB.

Post #1027118
Posted Sunday, May 15, 2011 10:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:26 AM
Points: 6, Visits: 234
Dear Friends

Read this it may give your query answer.

Overview of New Features in Microsoft SQL Server 2008 R2
Microsoft SQL Server 2008 R2 introduces lot many new features for Business Intelligence users, Developers and Database Administrators. This article gives you an overview of some of the new features in SQL Server 2008 R2.

Capitalize on Hardware Innovation

There was always a demand from customers to increase the number of logical processors supported in SQL Server. In SQL Server 2008 R2 the number of logical processors supported has been increased from 64 to 256 and it will take advantage of the multi-core technology. This will help improve performance and scalability for very large data warehousing applications.

Optimize Hardware Resources

This is a great new feature for database administrators as it will provide a real time insight into Server Utilization, Policy Violations etc. This feature will help organizations to strictly apply organization wide policies across servers thereby helping them maintain a healthy system.

Manage Efficiently at Scale

This feature will help database administrator to gain insight into growing applications and databases thereby helping them to ensure better management of database servers.

Enhance Collaboration Across Development and IT

Database Application development will be more closely integrated with Visual Studio 2010 which will help to ensure higher quality during the application development along with easier deployments and better handling of changes over time.



Master Data Services (MDS)

A Master Data Service (MDS) is a kind of data service that is responsible for: managing, in a single place, the uniqueness, integrity, quality, and interrelationships between the data that matters the most. This will improve the quality of your data because of centralized approach of defining; deploying and managing master data thereby ensure reporting consistency across systems.

Build Robust Analytical Applications

Using Microsoft Office Excel 2010 you can build robust analytical applications which will allow in-memory, column oriented processing engine to allow users to interactively explore and perform complex calculations on millions of data at lightening speeds. Using Microsoft Excel 2010 you can easily integrate data from multiple sources such as corporate databases, spreadsheets and external data sources.

Share and Collaborate with Confidence

Using Microsoft Office SharePoint 2010 users can easily publish reports to SharePoint sites thereby making it available across the organizations. The other advantage is that the reports can be refreshed automatically and you can also maintain version controlling and tracking using SharePoint. Once you start using Microsoft Office SharePoint the SharePoint Administrators will have the ability to set server policies and monitor them more effectively thereby securing the business critical information.

Support for Geospatial Visualization

Microsoft SQL Server 2008 R2 will provide support for geospatial visualization including mapping, routing, and custom shapes. It will also support SQL Spatial and will also provide integration with Microsoft Virtual Earth tiles.


Read more: New Features in Microsoft SQL Server 2008 R2 - MyTechMantra.com http://www.mytechmantra.com/LearnSQLServer/Microsoft_SQL_Server_2008_R2.html#ixzz1MUC7PkC9

Read more: New Features in Microsoft SQL Server 2008 R2 - MyTechMantra.com http://www.mytechmantra.com/LearnSQLServer/Microsoft_SQL_Server_2008_R2.html#ixzz1MUBwhj3d

Post #1109086
Posted Tuesday, May 17, 2011 11:50 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 4,406, Visits: 6,270
SQL 2008 R2 release was almost all about either extreme scale stuff or BI stuff. Not much at all for us relational engine types.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1110467
Posted Thursday, April 19, 2012 11:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 18, 2014 11:11 AM
Points: 2, Visits: 123
About SQL Server 2008

By using SQL Server you will be able to manage the database seamlessly. This system was designed to make work much easier because the organization of information will be done automatically. It doesn’t matter if the data is structured or semi-structured because this server can store all kinds of information – print, media, digital and so on. It makes a perfect backup storage for your information and can perform various functions that meet your needs, such as search, analysis, sharing, etc., across all the formats that you have stored.

With this server you can use the Filestream data type to reference any file that you have stored on the system. It also has Full Text Search, which makes it very easy to manage and improve the server’s performance.

About SQL Server 2008 R2

This server was released in 2010 and has all the features of the regular 2008 version, but it has added features that make it much better than its predecessor. It has a Master Data Service, which is a server that manages many features such as all the different entities and hierarchies. It also features Power Pivot for Excel and Share Point and Report Builder 3.0. It has many more visual features and has a high level of support for a new system on the market.
Post #1286875
Posted Tuesday, April 2, 2013 10:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 2, 2013 10:20 AM
Points: 1, Visits: 0
Data is compress in sql 2008
Post #1437996
Posted Wednesday, April 3, 2013 3:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:18 AM
Points: 2,886, Visits: 3,256
SQL 2008 R2 introduces support for Second Level Adderss Translation (SLAT). If you run it on Windows 2008 R2, you should see about a 5% performance improvement over running SQL 2008 on Windows 2008 on the same SLAT-capable hardware.

IMHO the big question is what is the difference between SQL 2008/2008R2 and SQL 2012. If you are into BI the difference is huge, particularly with data visualisation features that compare well with the best on the market.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1438223
Posted Thursday, April 4, 2013 5:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 23, 2014 10:46 PM
Points: 2,657, Visits: 1,556
On top of my head, Microsoft has changed the Lock Manager hash key algorithm in SQL 2008 R2. Few other internal changes as well, but can't really recall them.

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2010/01/18/improvement-in-minimizing-lockhash-key-collisions-in-sql-server-2008r2-and-its-impact-on-concurrency.aspx


Simon Liew
Microsoft Certified Master: SQL Server 2008
Post #1438729
Posted Tuesday, April 23, 2013 2:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 3:59 AM
Points: 1, Visits: 3
Thanks.
Post #1445317
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse