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 information is maintained within the msdb database?
Can you explain various data region available in ssrs with their use?
What is a view and what are its advantages?
What are commit and rollback in sql?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
System variable and temporary variables
What is 'write-ahead log' in sql server 2000 ?
Explain about nested stored procedure?
What is replication with database mirroring? : sql server database administration
What is correlated subquery in sql server?
Define compound operators?
What is outer join in sql server joins?
Difference between Sql server reporting services and Crystal reports?
Is resultset an interface?
What were the latest updates to SQL Azure service?