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 should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  


What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,


How to create a local temporary stored procedure?

0 Answers  


What are out-of-range errors with date and time literals?

0 Answers  


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  






When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,


How to enable tcp/ip protocol on a sql server?

0 Answers  


what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  


What is the query optimization statistics?

1 Answers  


What do you think of this implementation? Can this be implemented better?

0 Answers  


What is an sql server agent?

0 Answers  


What are truncate options available in sql server? : sql server database administration

0 Answers  


Categories