What are the new features in SQL Server 2005?
Answer Posted / hari
Management Studio
DMV
CLR Interegation
Database mirroring
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the types of table?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is an execution plan? When would you use it?
What are database states in ms sql server?
How can you check the version of sql server?
What are examples of triggers?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the different authentication modes in sql server? How can it be changed?
Please explain what is “asynchronous” communication in sql server service broker?
What is acid db?
What information is maintained within the msdb database?
Where do we use trace frag?
Can we use max in where clause?