x

Planning for SQL Server 2008 R2

SQL Server 2008 R2 is apparently planned for the first half of calendar year 2010. We're just about to do a chunk of work to move some of our SQL Server 2005 databases up to 2008. Is there anything we should factor into our planning to ease our upgrade path to 2008 R2 when it arrives?

more ▼

asked Oct 12 '09 at 12:15 PM in Default

Melvyn Harbour 1 gravatar image

Melvyn Harbour 1 ♦♦
1.4k 18 20 22

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The main 'adds' with SQL Server 2008 R2 are:

  • Scalability for very large scale data stores (in the 10s of Terabytes+)
  • 'Self-service' business intelligence
  • Deployment model
  • Management enhancements

I would say that the deployment model would have the biggest effect on most developers, as it promises to package up database and application deployments into a single logical unit, as a few third party tools allow you to do today. Whether they are as effective in reality remains to be seem. I know I was spectacularly underwhelmed by the IntelliSense in 2008 RTM.

more ▼

answered Oct 12 '09 at 12:29 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x562
x341
x68
x1

asked: Oct 12 '09 at 12:15 PM

Seen: 1778 times

Last Updated: Oct 15 '09 at 05:42 AM