1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are all new concepts in SQL Server 2008? That is
Exactly Difference between 2005 to 2008

Question Posted / vamsimadineni

Answers were Sorted based on User's Feedback



What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008..

Answer / kokkula raju

More powerful management
Policy Management feature
Improved performance and scalability
Storing high volume of data
Support for diverse types of data
Better security and availability
Security increased by data encryption
Availability increased by database mirroring
Changes for developers

Is This Answer Correct ?    14 Yes 2 No

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008..

Answer / jigar

Row Constructors

Output Clause

Compound Operators

Inline Variable Assignment

Grouping Sets

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

how to avoid cursors? : Sql server database administration

0 Answers  

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

What is a trigger?

7 Answers  

What is difference between equi join and inner join?

0 Answers  

What will be the maximum number of index per table?

0 Answers  




how to select a field with firstletter as capital and remaining are small letters

11 Answers  

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

What is check constraint in sql server?

0 Answers  

Explain syntax for dropping triggers?

0 Answers  

What are built in functions?

0 Answers  

Can XML be used to access data?

2 Answers  

what is the difference between procedure and function.

4 Answers   Thomson,

For more SQL Server Interview Questions Click Here
Categories