<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Difference between sql server 2005 and 2008
18 posts, Page 1 of 2
1
2
»»
Difference between sql server 2005 and 2008
Rate Topic
Display Mode
Topic Options
Author
Message
Shahzadi
Shahzadi
Posted Monday, February 25, 2008 5:39 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, November 05, 2012 4:51 AM
Points: 120,
Visits: 206
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
Post #459626
Tommy Bollhofer
Tommy Bollhofer
Posted Monday, February 25, 2008 7:28 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 PM
Points: 1,148,
Visits: 3,148
From the horse's mouth :D
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
Post #459675
Andras Belokosztolszki
Andras Belokosztolszki
Posted Monday, February 25, 2008 7:42 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367,
Visits: 1,585
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
Post #459682
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, February 25, 2008 8:20 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 12:49 PM
Points: 31,432,
Visits: 13,742
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
Post #459706
Joe Clifford
Joe Clifford
Posted Monday, February 25, 2008 10:38 PM
SSC-Addicted
Group: General Forum Members
Last Login: Monday, January 07, 2013 11:28 PM
Points: 433,
Visits: 618
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.
Post #460059
Vivien Xing
Vivien Xing
Posted Tuesday, February 26, 2008 12:47 PM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:19 AM
Points: 1,279,
Visits: 2,191
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
Post #460491
CC-597066
CC-597066
Posted Tuesday, February 26, 2008 6:08 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, April 25, 2013 5:02 PM
Points: 46,
Visits: 802
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
Post #460638
Joe Clifford
Joe Clifford
Posted Tuesday, February 26, 2008 10:19 PM
SSC-Addicted
Group: General Forum Members
Last Login: Monday, January 07, 2013 11:28 PM
Points: 433,
Visits: 618
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
Post #460683
Martin Graves
Martin Graves
Posted Monday, May 05, 2008 11:27 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:44 PM
Points: 8,
Visits: 183
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.
Post #495138
bcronce
bcronce
Posted Monday, May 05, 2008 1:14 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 03, 2012 7:36 AM
Points: 127,
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?
Post #495208
« Prev Topic
|
Next Topic »
18 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
