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 |
what is a join? : Sql server database administration
What is the difference between push and pull subscription? : sql server replication
Can a database be shrunk with users active?
Are resultset updatable?
What is the Disadvantage of indexed sequential file.
what are the advanced features in sql 2008?
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
Explain timestamp datatype?
What are the basic features of a trigger in ms sql server?
What are key constraints?
How to use wildcard characters in like operations in ms sql server?
Oracle (3253)
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)