SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Difference between sql server 2005 and 2008


Difference between sql server 2005 and 2008

Author
Message
Shahzadi
Shahzadi
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 Visits: 284
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
Tommy Bollhofer
Tommy Bollhofer
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1766 Visits: 3359
From the horse's mouth BigGrin

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 @sqlscribe
Andras Belokosztolszki
Andras Belokosztolszki
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2235 Visits: 1585
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



Andras Belokosztolszki, MCPD, PhD
GoldenGate Software
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61958 Visits: 19101
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: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Joe Clifford
Joe Clifford
SSC Eights!
SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)

Group: General Forum Members
Points: 821 Visits: 619
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.



Vivien Xing
Vivien Xing
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1850 Visits: 2204
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
CC-597066
CC-597066
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 1087
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:

http://download.microsoft.com/download/2/d/f/2df66c0c-fff2-4f2e-b739-bf4581cee533/SQLServer%202008CompareEnterpriseStandard.pdf
Joe Clifford
Joe Clifford
SSC Eights!
SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)SSC Eights! (821 reputation)

Group: General Forum Members
Points: 821 Visits: 619
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



Martin Graves
Martin Graves
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 280
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.
bcronce
bcronce
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 Visits: 517
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search