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

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,


What is an execution plan? When would you use it?

0 Answers  


Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,


What are the different types of collation sensitivity?

0 Answers  


What are orphan records?

0 Answers  






Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,


Should you normalize audio?

0 Answers  


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  


What are the results of running this script?

0 Answers  


What is the difference between composite index and covering index?

0 Answers  


What are the properties of sub-query?

0 Answers  


What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  


Categories