SQL:
  1. Difference between stored procedures and functions
  2. Different Types of triggers
  3. What is constraints and types of constraints
  4. What is referential integrity
  5. Dimensional models
  6. Difference between temporary tables and table variables
  7.  indexed views
  8.  index types
  9.  clustered vs nonclustered index
  10.  execution plan
  11.  table scan vs index scan vs index seek
  12.  Paging
  13.  Fragmentation
  14.  how to lower heap fragmentation
SSIS:

  1. Lookup transformation
  2.  Checkpoints
  3.  Breakpoints
  4.  how to handle incremental data load
  5.  transformations used
  6.  how to zip files