From: nsubbu1986@gmail.com   
      
   Hi Expert am not a cheater. i have to learning for these qs.already learnt   
   sqldba with fullfledge.but now i forget all subj bcz some gap after learning   
   and spend time in my hometime and some problem is dre.that'y am asking u.   
   i have some doubts please clarify   
      
   > 2. Log shipping has been set up new and is running fine. All on a sudden   
   during the after hours, it starts failing. What could be the possible reasons?   
      
   > 3. There is excessive performance issues on a database server. What are the   
   steps taken for the analysis and resolution?   
      
      
   > 6. Running SQL Profiler for troubleshooting is causing high performance   
   issues. What are the alernatives?   
      
   > 8. What is High Availability and what solutions could be implemented on SQL   
   Server to achieve this?   
      
   > 9. You need to restart SQL Server services on an Active node in a two node   
   cluster. How would you do it?   
      
   > 10. How would you patch SQL Servers in a fail-over cluster?   
      
   > 12. How to optimise memory usage in a multi instance SQL Server?   
      
   > 13. What is the default port in SQL Server, how to find it and how to   
   reconfigure it?   
      
   > 14. What all are the system databases in SQL Server 2008?   
      
   > 15. What is the difference between index Re-org and index Rebuild?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)