DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

Question Posted / mohamed ibrahim

2 Answers
5453 Views
ADP, I also Faced
E-Mail Answers

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 do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers

How to optimize stored procedure optimization?

0 Answers

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers TCS,

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers

What is the default value of an integer data type in sql server 2005?

0 Answers

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers IBM,

What is model database in sql server?

0 Answers

Define Check points and End Points?

1 Answers

Mention the uses of stored procedures.

0 Answers

What is a covered index?

0 Answers

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers

For more SQL Server Interview Questions Click Here