1. How cursor work?
  2. How we can optimize the report generation performance?
  3. What is indexes?
  4. Which way we can remove the duplicate data other than 'distinct '?
  5. How we can replace cursor in report generation?ans inner join
  6. How we can restrict particular data in table  while inserting?ans: trigger...check constraint..
  7. What is faster group by or distinct and why?
  8. Recursive method in ssis 
  9. how to select dynamic flat file in SSIS 
  10. what is dynamics partition
  11. is good to have many to many relationships is Ssas
  12. what is alternatives for this
  13. what is bulk insert advantage and disadvantages