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 checksum in sql server.........???
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
how many type of subquery?
what is Full Text Search ?
What do you mean by an execution plan? Why is it used?
How you can find out if an index is useful to the optimizer?
How to get the definition of a user defined function back?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
What is the sql case statement used for? Explain with an example?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What does the automatic recovery do?
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)