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 |
explain query execution plan
Explain the dbcc pintable command when would you use it?
What is difference between view and materialized view?
How to modify an existing user defined function?
Does a sql server 2005 select statement require a from?
How would you use user_constraints table in DB?
Is sql different from sql server?
What is an index?
why SQL server is more used to store database rather than Access
What is a data source file?
What is difference between aggregate and analytic function?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
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)