Interested to Buy Any Domain ? << Click Here >> for more details...
what are the new features of sql server 2005?
- 8 Answers
- 13264 Views
- HP, Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / nutan sharma
Report Service manager
in built Reporting Feature Available in 2005
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Difference between report and query parameter. Why do we need different type of parameter?
What is the need for group functions in sql?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is the purpose of update statistics and scope_identity() function?
What is the difference between Stored Procedures and triggers?
Describe how to use the linked server?
How do I view a script in sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is the sql profiler?
How many clustered indexes there can be on table ?
What is the difference between index seek vs. Index scan?
Explain the architecture of ms sql reporting service?
What is an execution plan? How would you view the execution plan?
