February 25, 2008 at 5:39 am
Hi guys..
can anybody refere me any article or can tell me what's the basic difference between sql server 2005 and 2008, acutally i want to move to 2008 but, if there not much mager difference then i won't..
Thanks and looking forward.
-MALIK
February 25, 2008 at 7:28 am
From the horse's mouth 😀
http://www.microsoft.com/sql/2008/prodinfo/newfeatures.mspx
Don Schlichting also wrote a few good articles on some of the new features available in 2008.
http://www.databasejournal.com/features/mssql/article.php/3691821
http://www.databasejournal.com/features/mssql/article.php/3697056
http://www.databasejournal.com/features/mssql/article.php/3702381
Tommy
Follow @sqlscribeFebruary 25, 2008 at 7:42 am
The new features are summarized on https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470
There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.
Regards,
Andras
February 25, 2008 at 8:20 am
I'd argue that if you are considering the move, and can wait until the fall, I'd go with 2008. There are now going to be releases every 2-3 years, which means you'll get about 6 years of support on a version. So if you go to 2005, you'll be considering an upgrade in 3 years, which you may not need. If you go 2008, you can still upgrade in 3 years if you want, but can wait 6 years if you don't need to.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 25, 2008 at 10:38 pm
The Denver SQL Server Users group has had some really good presentations over the last couple of months on the new features in SQL 2008 including one from Paul Nielsen just last week shortly after he got back from "Jump Start" up in Redmond (if I remember the name of the event correctly).
A couple of caveats on all of the "new features" for SQL 2008, the triage to determine which features will be in the various editions is still in progress. Many/most of the new/very cool features like data compression, partitioned indexes, policies, etc. are only going to be in the enterprise edition. Unless you're planning on running enterprise edition a lot of the features that are in the CTP's will probably not be in SQL 2008 standard, etc.
On other minor but often overlooked issue - SQL 2008 will only be 64-bit, if you're buying new hardware shouldn't be an issue but if you're planning on using existing hardware... also, if you've got dependencies on third party drivers (e.g. oracle) best be sure that a 64-bit version is available/works.
February 26, 2008 at 12:47 pm
Good input. I was looking for these kinds of information.
Webcast is also a good place to go. http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=webcasts
February 26, 2008 at 6:08 pm
Joe Clifford (2/25/2008)
...On other minor but often overlooked issue - SQL 2008 will only be 64-bit, if you're buying new hardware shouldn't be an issue but if you're planning on using existing hardware... also, if you've got dependencies on third party drivers (e.g. oracle) best be sure that a 64-bit version is available/works.
This SQL Server 2008 version feature comparison implies that there will be a 32 bit version:
February 26, 2008 at 10:19 pm
CC -
I stand corrected; apparently there will be 32 bit versions of SQL 2008 which is a change from what I had read at CTP5, I thought it was pretty aggressive of MS to force folks to 64-bit, if I remember correctly they said that only developer would run 32-bit at that point in time.
That document is dated 2/22/2008 and well worth a read, thanks for pointing it out. This is the first "official" thing I've seen that clarifies what will be in each version - just be sure to note the disclaimer on the bottom of each page.
Joe
May 5, 2008 at 11:27 am
During recent Hero's (SQL 2008 + Server 2008 + VS 2008) events, MS SQL guys noted that NEXT release of SQL (2010+) will be 64-bit only. That bit of info has not been confirmed.
May 5, 2008 at 1:14 pm
I've seen many times where MS said they plan on post Windows Server 2008 and SQL 2008 to be 64bit only. If you don't have a 64bit server by 2011, you have to be trying to not upgrade. With old memory holding stagnant for price drops and new kingston/crucial DDR2-667 ecc memory going for 2x2GB going for $120, how would someone not want a newer computer with those prices?
November 1, 2008 at 4:09 am
Could somebody refer a site where the differences between SQL Server 2008 and 2005 versions are detailed. Also, being a small sized organisation is it really necessary to upgrade to SQL Server 2008 ? What are the advantages of upgrading ?
I would really appreciate help in this regard.:)
November 1, 2008 at 6:46 am
arijit_manna (11/1/2008)
Could somebody refer a site where the differences between SQL Server 2008 and 2005 versions are detailed. Also, being a small sized organisation is it really necessary to upgrade to SQL Server 2008 ? What are the advantages of upgrading ?I would really appreciate help in this regard.:)
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
Tommy
Follow @sqlscribeDecember 23, 2009 at 8:54 pm
Hii dude find the link ...http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
January 5, 2011 at 6:19 am
SQL SERVER 2005:
1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is introduced.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.Cant encrypt
13.Can Compress tables and indexes.(Introduced in 2005 SP2)
14.Datetime is used for both date and time.
15.Varchar(max) and varbinary(max) is used.
16.No table datatype is included.
17.SSIS is started using.
18.CMS is not available.
19.PBM is not available.
20.PIVOT and UNPIVOT functions are used.
SQL SERVER 2008:
1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is used.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.Can encrypt the entire database introduced in 2008.
--check it(http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx)
(http://qa.sqlservercentral.com/articles/Administration/implementing_efs/870/)
(http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx)
(http://www.sql-server-performance.com/articles/dev/encryption_2005_1_p1.aspx)
(http://geekswithblogs.net/chrisfalter/archive/2008/05/08/encrypt-documents-with-sql-server.aspx)
13.Can compress tables and indexes.
-http://www.mssqltips.com/tip.asp?tip=1582
14.Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone
is used.
15.Varchar(max) and varbinary(max) is used.
16.Table datatype introduced.
17.SSIS avails in this version.
18.Central Management Server(CMS) is Introduced.
-http://msdn.microsoft.com/en-us/library/bb934126.aspx
-http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-Central-Management-Servers-have-you-seen-these.aspx
19.Policy based management(PBM) server is Introduced.
-http://www.mssqltips.com/tip.asp?tip=1492
-http://msdn.microsoft.com/en-us/library/bb510667.aspx
20.PIVOT and UNPIVOT functions are used.
-http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/
--
Thanks & Regards,
N.S.Sathish(SQL DBA)
July 17, 2011 at 4:52 am
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply