InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:15:46 GMT20http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxAh, so we have a smart A#UY$ in the crowd , eh?Mon, 18 Jul 2011 23:11:56 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxhttp://www.microsoft.com/sqlserver/en/us/product-info/previous-versions.aspxMon, 18 Jul 2011 21:56:21 GMTJinu Varghesehttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxThis post was initially created over 3 years ago. :-)Sun, 17 Jul 2011 12:49:01 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxYou may check thishttp://sharepointsolution2010.blogspot.com/2011/07/2000-2005-2008-sql-server-version.htmlSun, 17 Jul 2011 04:52:27 GMTbsreddy00http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxSQL 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 Handling5.Varchar(Max) data type6.DDL Triggers7.DataBase Mirroring8.RowNumber function for paging9.Table fragmentation10.Full Text Search11.Bulk Copy Update12.Cant encrypt13.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 Handling5.Varchar(Max) data type6.DDL Triggers7.DataBase Mirroring8.RowNumber function for paging9.Table fragmentation10.Full Text Search11.Bulk Copy Update12.Can encrypt the entire database introduced in 2008. --check it(http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx) (http://www.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=158214.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.aspx19.Policy based management(PBM) server is Introduced. -http://www.mssqltips.com/tip.asp?tip=1492 -http://msdn.microsoft.com/en-us/library/bb510667.aspx20.PIVOT and UNPIVOT functions are used. -http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/Wed, 05 Jan 2011 06:19:27 GMTsathieshsqlhttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxHii dude find the link ...http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspxWed, 23 Dec 2009 20:54:20 GMTpmaddy23http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspx[quote][b]arijit_manna (11/1/2008)[/b][hr]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.:)[/quote][url=http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx]http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx[/url]Sat, 01 Nov 2008 06:46:11 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxCould 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.:)Sat, 01 Nov 2008 04:09:04 GMTarijit_mannahttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxI'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?Mon, 05 May 2008 13:14:01 GMTbcroncehttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxDuring 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.Mon, 05 May 2008 11:27:40 GMTMartin Graveshttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxCC -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.JoeTue, 26 Feb 2008 22:19:42 GMTJoe Cliffordhttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspx[quote][b]Joe Clifford (2/25/2008)[/b][hr]...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.[/quote]This SQL Server 2008 version feature comparison implies that there will be a 32 bit version:[url]http://download.microsoft.com/download/2/d/f/2df66c0c-fff2-4f2e-b739-bf4581cee533/SQLServer%202008CompareEnterpriseStandard.pdf[/url]Tue, 26 Feb 2008 18:08:40 GMTCC-597066http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxGood 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=webcastsTue, 26 Feb 2008 12:47:33 GMTVivien Xinghttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxThe 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.Mon, 25 Feb 2008 22:38:54 GMTJoe Cliffordhttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxI'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.Mon, 25 Feb 2008 08:20:51 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxThe new features are summarized on [url]https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470[/url]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, AndrasMon, 25 Feb 2008 07:42:56 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxFrom the horse's mouth :D[url=http://www.microsoft.com/sql/2008/prodinfo/newfeatures.mspx]http://www.microsoft.com/sql/2008/prodinfo/newfeatures.mspx[/url]Don Schlichting also wrote a few good articles on some of the new features available in 2008.[url=http://www.databasejournal.com/features/mssql/article.php/3691821]http://www.databasejournal.com/features/mssql/article.php/3691821[/url][url=http://www.databasejournal.com/features/mssql/article.php/3697056]http://www.databasejournal.com/features/mssql/article.php/3697056[/url][url=http://www.databasejournal.com/features/mssql/article.php/3702381]http://www.databasejournal.com/features/mssql/article.php/3702381[/url]Mon, 25 Feb 2008 07:28:42 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic459626-146-1.aspxHi 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.-MALIKMon, 25 Feb 2008 05:39:21 GMTShahzadi