1. How to append 2 MDX queries?
  2. How to pass array value to each loop and from loop to Pass to each individual execute sql task and it’s precedence?
  3. Difference between Unicode and NonUnicode
  4. Display 1 to 50 numbers using CTE
  5. Can we have index on CHAR? If yes,  on leaf node what is get stored? Data or Pointer?
  6. Difference between script component And script task?
  7. For subscription, Where Mail or SMTP Server will configure?
  8. SqlCMD for Automation
  9. How to Process Partition using sqlcmd and xml command?
  10. Factless Fact used for join 2 tables
  11. How to separate Comma separated values in tabular format with employee id column?
  12. New feature of DB configuration to synch procedure on every server present in SSDT