What are all new concepts in SQL Server 2008? That is
Exactly Difference between 2005 to 2008
Answers were Sorted based on User's Feedback
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 |
Answer / jigar
Row Constructors
Output Clause
Compound Operators
Inline Variable Assignment
Grouping Sets
| Is This Answer Correct ? | 0 Yes | 0 No |
Define tool Manage Statistics in SQL Server 2000 query ?
what is a cursor and what is its use?
What are the purposes of floor and sign functions?
what is the Enterprise manager(2000) and management studio (2005)?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is difference between order by and group by?
If we use where clause in the left outer join then how the query would behave/act?
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
What are functions
What is difference between views and tables?
What is the difference between constraints and triggers?
what is the system function to get the current user's user id? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)