Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11104 Views
- CarrizalSoft Technologies, L&T, I also Faced
- E-Mail Answers
Answer Posted / g.ashok
Non clustered index is fast
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How will you decide the active and passive nodes?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What are user defined functions in ms sql server?
How to create new table with "create table" statements?
Can we insert data into a view?
Explain where clause?
What do you understand by a stored procedure?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What are different types of schemas?
What is parameterized reports in ssrs ?
What is primary key and example?
What is nolock hint in sql server 2008
Explain the working of sql privileges?
Explain the disadvantages/limitation of the cursor?
