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 IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,


Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  


How can I check that whether automatic statistic update is enabled or not?

0 Answers  


Explain the different types of backups available in sql server? : sql server database administration

0 Answers  






Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  


Which virtual table does a trigger use?

3 Answers  


What are the steps you should follow to start sql server in single-user mode?

0 Answers  


How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,


What is a Stored Procedure?

8 Answers  


whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,


What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  


Categories