Which Edition of SQL Server 2008 R2 should you use?

Posted by BuckWoody on SQL Blog See other posts from SQL Blog or by BuckWoody
Published on Wed, 21 Apr 2010 14:03:59 GMT Indexed on 2010/04/21 15:14 UTC
Read the original article Hit count: 289

Filed under:

Latest Version

|

SQL Server 2000

|

SQL Server 2008

|

web

SQL Server 2008 R2 has just released to manufacturing (RTM’d) as I write this. With each new release, we make changes to the “Editions” we offer.

A SQL Server “version” deals with the major changes in the product – and “edition” is a set of features and capabilities within that version (you’re welcome).

So… definitely run over to http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx and check out the changes. For instance, did you know that SQL Server Express now supports 10GB databases? Well, then get over there and read what each edition does.

Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

© SQL Blog or respective owner

Related posts about Latest Version

iPod OS version, Xcode version and Mac OS X version

as seen on Super User - Search for 'Super User'
Hello everyone My Mac OS X version is 10.5.8 Xocde 3.1.4 I hope to debug my app on the iPod Touch iPod OS version 3.1.3(7E18) Organizer told me that I need newest Xcode. I downloaded and try to install the newest Xcode, but it told me I need new Mac Os X. So I clicked my Mac mini's software update… >>> More
System.Web.Services.Protocols.SoapException - Security perssmission issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Can any one help me to resolve this error.My website hosted on shared environment. Server Error in '/' Application. System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions… >>> More
Get Last Version in TFS doesn't download the last version in Version Control

as seen on Stack Overflow - Search for 'Stack Overflow'
I have modified default.aspx. When I use Get Last Version in TFS 2005, it still keeps my local version. How to really get last version in Version Control ? >>> More
Failed to resolve artifact. Missing: ---------- 1) org.codehaus.mojo:gwt-maven-plugin:jar:1.3-SNAPSHOT

as seen on Stack Overflow - Search for 'Stack Overflow'
i want to use the addon vaadin Timeline, so i have to make "gwt-maven-plugin 3.1" as i know ,my pom.xml is the following : <?xml version="1.0"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache… >>> More
Get latest sql rows based on latest date and per user

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following table: RowId, UserId, Date 1, 1, 1/1/01 2, 1, 2/1/01 3, 2, 5/1/01 4, 1, 3/1/01 5, 2, 9/1/01 I want to get the latest records based on date and per UserId but as a part of the following query (due to a reason I cannot change this query as this is auto generated by a tool but… >>> More

Related posts about SQL Server 2000

Windows 2000 uninstall on a dual-boot 2000/XP system

as seen on Super User - Search for 'Super User'
While several questions have already been answered about removing an OS from a dual-booting machine, most refer to Windows 7 vs. Linux/Vista/XP. I have W2K installed on my older HDD (Drive C). Later on I bought a new HDD and installed XP's under W2K environment. Each time I turned my PC on, I had… >>> More
SQL 2000 Backup/Export Process - Can't find SQL 2000 Enterprise Manager, Can't use Mgmt Studio Expre

as seen on Server Fault - Search for 'Server Fault'
I need to make a backup of a client's SQL 2000 database, however there are a few issues preventing me from doing so using the traditional methods. I've tried using SQL Management Studio Express, but the host doesn't give sufficient privileges to create a backup and I'm getting some strange error messages… >>> More
SQL Server 2000, yes 2000 password hash

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to store a password has in a SQL server 2000 database. The information isn't critical but I really don't want to store the password in clear text. How can I get a unique hash (sha, sha1, md5, etc) in SQL server 2000 as HashBytes isn't available. I'm not looking for compiled DLL or the ilk… >>> More
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
RRAS won’t start with 8007042a or event ID 7024, aka the “routing remote access unable to load Iprtrmgr.dll”

as seen on Server Fault - Search for 'Server Fault'
History: The history of this error, which has mostly gone unsolved, dates back to Windows 2000. Platforms affected: Windows Server 2008 R2, Server 2008, Server 2003 R2, Server 2003, Server 2000 (both 32-bit and 64-bit installs are affected). Error Messages Event ID: 7024 The Routing and Remote… >>> More