SQL Server 2005 versus 2008
Not what you're looking for?
Can you help me locate information about the differences between SQL Server 2005 and SQL Server 2008?
What do you think are the three most significant changes/improvements and why?
How would the changes benefit you in using this updated version? Do you think it would be required to upgrade to the newer version and why?
What do you think would be the difficulties associated with upgrading to the new version?
Purchase this Solution
Solution Summary
A comparison of SQL Server 2005 and 2008, improvements, disadvantages, and reasons for changes.
Solution Preview
Response using the questions: I also added information about the SQL server 2005 to help with understanding the upgrades.
SQL 2005 introduced some new improvements over former SQL programs to help better manage data and data inquiries. Among these were native support for managing the XML data and all relational data used for information storing and use. The data could be used both literally and in queries. XML could be associated with XSD and it extended to the XML DML query extension. SQL server 2005 could be used over web services using TDS and returned as XML. CLR integration was a new feature of 2005 and relational data under T-SQL could better handle error catching. Multiple active results sets were available with 2005, so databases could be used for multiple purposes over connections. Dynamic ...
Purchase this Solution
Free BrainMass Quizzes
Operations Management
This quiz tests a student's knowledge about Operations Management
Basics of corporate finance
These questions will test you on your knowledge of finance.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.