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

What is the xml datatype?

0 Answers  

What is the process of indexing?

0 Answers  

Explain a join?

0 Answers  

select empid empname from employee What is the result for the about query?

4 Answers  

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  




What happens if ntwdblib.dll is missing on your machine?

0 Answers  

Can we use where clause with group by?

0 Answers  

What are types of subqueries?

0 Answers  

What are the difference between clustered and a non-clustered index?

0 Answers  

What do you mean by a Composite primary key?

0 Answers   Genpact,

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

What is dbcc command in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories