Groups > comp.databases.ms-sqlserver > #354

Re: SQL Server 2008 R2 vs SQL Server 2008?

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Server 2008 R2 vs SQL Server 2008?
Date	2011-05-18 23:47 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9EE9F1F9D123CYazorman@127.0.0.1> (permalink)
References	<29958c1e-cb26-407c-acd7-ba64dca39f5c@t16g2000vbi.googlegroups.com>

Show all headers | View raw

Joe Cool (joecool1969@live.com) writes:
> What are the differences between the two?
> 
> Is there an advantage to use R2?
> 
> Is there any reason to even use the non-R2 version?

Depends which components of SQL Server you use. For the Database Engine
there are very few differences. On the other hand, in the BI space there
are lots of new stuff. Since I'm not into BI myself, I can't relate them.

As for the tools, there is quite a nasty bug in SSMS 2008 R2: when you lose 
connection in your query window, SSMS R2 silently reconnects but dumps you 
in your default database (which typically is master). Also the spid in the 
status bar is not open.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

SQL Server 2008 R2 vs SQL Server 2008? Joe Cool <joecool1969@live.com> - 2011-05-18 12:01 -0700
  Re: SQL Server 2008 R2 vs SQL Server 2008? Gene Wirchenko <genew@ocis.net> - 2011-05-18 13:51 -0700
    Re: SQL Server 2008 R2 vs SQL Server 2008? Joe Cool <joecool1969@live.com> - 2011-05-20 14:52 -0700
  Re: SQL Server 2008 R2 vs SQL Server 2008? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-18 23:47 +0200

csiph-web