DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

Answers were Sorted based on User's Feedback



DIFFERENCE BETWEEN SQL SERVER 2005 and 2008..

Answer / rohit bhosale

Sql SErver 2008 exist with a highly available concepts that
are helpful to provide data security or protection,to
improve performance while SQL Server 2005 is lack of these
concepts hence We all are preferable to use 2008.

Is This Answer Correct ?    3 Yes 0 No

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008..

Answer / dinesh rathod

1, XML datatype is introduced. XML datatype is used. 2, Can not encrypt the entire database.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to create a view with data from multiple tables?

0 Answers  


how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,


How to provide default values to function parameters?

0 Answers  


What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  


What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,






How to stop a loop early with break statements in ms sql server?

0 Answers  


what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,


What happens if you are trying to access a schema not owned by you?

0 Answers  


What do you understand by replication in sql server?

0 Answers  


Do you know what is fill factor and pad index?

0 Answers  


What is equi join with example?

0 Answers  


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  


Categories