May 8, 2008 at 3:09 am
Good article. When are you writing the difference beween SQL Server 2005 and SQL Server 2008.
🙂
May 8, 2008 at 9:08 pm
Nice Article
September 22, 2008 at 11:13 pm
Nice article. But people look for programmatical changes like datatype difference. Please take care about this one.
December 12, 2008 at 1:05 pm
Good Article Steve.
Do you have the exact difference on SQL server 2000 cluster vs SQL server 2005 cluster
December 12, 2008 at 1:16 pm
What do you mean by "exact difference"? Everything that has changed?
Even if I had the document, you'd have to carefully research it yourself. If you have a cluster I recommend you dig into the upgrade notes for clusters on the 2005 install.
December 12, 2008 at 7:55 pm
Thanks Steve for your response.
If you have any metrix or tablular format shows features that are available in MS SQL server Cluster 2005 compare to MS SQL server 2000
December 21, 2008 at 9:05 am
Sorry for the delay, I must be unsubscribed from this thread for some reason.
you can try here: http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx
no table, but it talks about 2005 clustering. Don't forget a lot of clustering takes place at the OS level, so depending on if you are changing OSes, you might really need to learn more about the newer OS features and issues with regard to clustering.
December 21, 2008 at 9:06 am
I hadn't really planned on writing a lot about the differences between 2005 and 2008 as it seems 2008 is more of a 2005.5 to me, the core is very similar or the same, and there have been things added on.
January 29, 2009 at 12:03 am
Haaaa,
Steve, you have managed to make me look EXTREMELY clever when explaining these "things" to the world outside SQL..hehe(not that I am not...)
But truth be told,a few individuals,when put to task can comprehensively explain the basic differences between these two versions of SQL....it's also IMPORTANT for us to know what they are,they are the basics and as we all know, all we hope to know is built on just how much we cared to understand the basics.
Personally, I had despaired on ever finding any PROPER let alone well researched explanation,please be assured,googling it does not help very much.,maybe I have bad english..hehe
Steve,really,thanks alot, you have single-handedly increased my cred,...and amount of free drinks...
September 9, 2016 at 4:32 am
1.Transparent Data Encryption. The ability to encrypt an entire database.
2.Backup Encryption. Executed at backup time to prevent tampering.
3.External Key Management. Storing Keys separate from the data.
4.Auditing. Monitoring of data access.
5.Data Compression. Fact Table size reduction and improved performance.
6.Resource Governor. Restrict users or groups from consuming high levels or resources.
7.Hot Plug CPU. Add CPUs on the fly.
8.Performance Studio. Collection of performance monitoring tools.
9.Installation improvements. Disk images and service pack uninstall options.
10.Dynamic Development. New ADO and Visual Studio options as well as Dot Net 3.
11.Entity Data Services. Line Of Business (LOB) framework and Entity Query Language (eSQL)
12.LINQ. Development query language for access multiple types of data such as SQL and XML.
13.Data Synchronizing. Development of frequently disconnected applications.
14.Large UDT. No size restriction on UDT.
15.Dates and Times. New data types: Date, Time, Date Time Offset.
16.File Stream. New data type VarBinary(Max) FileStream for managing binary data.
17.Table Value Parameters. The ability to pass an entire table to a stored procedure.
18.Spatial Data. Data type for storing Latitude, Longitude, and GPS entries.
19.Full Text Search. Native Indexes, thesaurus as metadata, and backup ability.
20.SQL Server Integration Service. Improved multiprocessor support and faster lookups.
21.MERGE. TSQL command combining Insert, Update, and Delete.
22.SQL Server Analysis Server. Stack improvements, faster block computations.
23.SQL Server Reporting Server. Improved memory management and better rendering.
24.Microsoft Office 2007. Use OFFICE as an SSRS template. SSRS to WORD.
25.SQL 2000 Support Ends. Mainstream Support for SQL 2000 is coming to an end.
September 9, 2016 at 5:06 am
Please note: 9 year old thread.
15. Dates and Times. New data types: Date, Time, Date Time Offset.
16. File Stream. New data type VarBinary(Max) FileStream for managing binary data.
17. Table Value Parameters. The ability to pass an entire table to a stored procedure.
18. Spatial Data. Data type for storing Latitude, Longitude, and GPS entries.
None of these were in SQL 2005, nor were a few others on the list. They were added in 2008
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 46 through 55 (of 55 total)
You must be logged in to reply to this topic. Login to reply