What is differences between sqlserver2005 and sqlserver2008

Posted Date: 10 Aug 2012 Posted By:: Rama Murthy Member Level: Silver Member Rank: 1261 Points: 1 Responses: 4

what is differences between sqlserver2005 and sqlserver2008

pls send the answer with clear explanation

Responses

#683939 Author: Prasad kulkarni Member Level: Diamond Member Rank: 8 Date: 11/Aug/2012 Rating: Points: 4
There are many advanced thing you can find in SQL 2008 - A compression backup for files exist in SQl 2008 - Less data written to disk as CPU is used to compress the data before it is written to disk - Migration made very easy from 2005 to 2008 but that was not the case with 2000 to 2005, you can use Dettach/attach method, Backup from 2005 and restore it in 2008, or Use GUI tool to do migration - SQL 2008 has CMS which is Central Management Server used to manage multiple SQL Servers at once - SQL Server 2008 also introduced ploy based management in which you to define and enforce policies for configuring and managing SQL Server - In SQL 2008 Reporting Services no longer requires IIS hope it helps Thanks Koolprasd2003 [DotNetSpider MVM]

#683968 Author: ubendiran.th Member Level: Silver Member Rank: 2519 Date: 11/Aug/2012 Rating: Points: 0
Hi, Refer the below site for more detail. http://wiki.answers.com/Q/Difference_between_SQL_Server_2005_and_SQL_Server_2008 Regards, Ubendiran

#683979 Author: SonyMadhu Member Level: Gold Member Rank: 45 Date: 11/Aug/2012 Rating: Points: 3
Hi, Yes When we go with Sql Server 2008 there is a comression of backup files, And Compared to Sql server 2005, 2008 takes less time in this also. In Sql Server 2008 New data type for Date and Time Compared to 2005, 2008 performs actions very fast We can store large amount of data in compare to 2005 Migration is also very easy Hope this will give some idea Regards, Madhu Be so hapy wen others look at you,they become hapy too

#687984 Author: Om yadav Member Level: Silver Member Rank: 324 Date: 07/Sep/2012 Rating: Points: 3
Hi.. There are many difference between sql server 2005 and sql server 2008. New Feature of sql server 2008. 1. In sql server 2008 divided datetime into two part like Date,time 2. and a data type include to-which Name (Datetime2) 3. you can assign default value when we define variable like this. Declare @Count int=5 4. and define increment and decrement operator like Declare @Count int set @Count+=1 or Set @Count-=1 5. and intelligence use in sql server 2008

Post Reply

You must Sign In to post a response.

	Next : How to convert Physical XML files into Sqlserver Tables
	Previous : How to show value in one column based on the other column in sql???
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
Today

Last 7 Days

Awards & Gifts