SQL server book - 2005 or 2008?
in [Server Configuration]
|
Prev: ANN: New version of Database Workbench, the multi-DBMS IDE now available!
Next: Best Practice - Converting ntext to nvarchar(max)
From: Jack Jolly Jack on 22 Apr 2010 07:59 I need a refresher book on SQL server. Our short-term application will use 2005 but I'm seeing DBA books on Amazon for 2008. Can I get a 2008 book and assume that most of it is also applicable to 2005 - or are there major differences between the two? Thanks in advance - Jack
From: Uri Dimant on 22 Apr 2010 08:04 Jack Yes most of SQL Server Engine \Optimizer behaviour is applicable to 2005 as well. Sure there are new features implemented only since SQL Server 2008 . "Jack Jolly" <Jack Jolly(a)discussions.microsoft.com> wrote in message news:5D76F406-042C-404C-8DDE-3445E42BED1C(a)microsoft.com... >I need a refresher book on SQL server. Our short-term application will use > 2005 but I'm seeing DBA books on Amazon for 2008. Can I get a 2008 book > and > assume that most of it is also applicable to 2005 - or are there major > differences between the two? > > Thanks in advance - Jack
From: Dan Guzman on 22 Apr 2010 08:22
> Can I get a 2008 book and > assume that most of it is also applicable to 2005 - or are there major > differences between the two? SQL Server 2008 introduces many new features, including new data types (e.g. date, time), T-SQL statements (e.g. MERGE) and scalability enhancements (e.g. filtered indexes). However, this builds on earlier versions so the majority of a SQL 2008 book applies to SQL 2005 as well. I recommend a SQL 2008 book but be aware of the new stuff that isn't applicable to SQL 2005. New features are outlined in the SQL 2008 What's New topics in the Books Online (http://msdn.microsoft.com/en-us/library/bb500435(v=SQL.100).aspx). -- Hope this helps. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/ "Jack Jolly" <Jack Jolly(a)discussions.microsoft.com> wrote in message news:5D76F406-042C-404C-8DDE-3445E42BED1C(a)microsoft.com... > I need a refresher book on SQL server. Our short-term application will > use > 2005 but I'm seeing DBA books on Amazon for 2008. Can I get a 2008 book > and > assume that most of it is also applicable to 2005 - or are there major > differences between the two? > > Thanks in advance - Jack |