Joins,index,sp,trigger,cursor,view,function
mainly asked about join queries
delete duplicate queries
select top 3rd record
event handlers
logging

optimisation SQL: 1) What is Statistics in SQL Server? 2) What is SQL Profiler? 3) What is MERGE in SQL? What is the Syntax? 4) How can we debug SP? Tills last day executed in 2 minutes and now in 2 Hours 5) Temp Table vs Table Variable? 6) 2nd Highest salary dept wise 7) Where store in SQL for execution plan 8) Isolation in SQL 9) Primary key has Clustered Index? How can we apply clustered index in another column?
SSIS: 1) How can we load multiple extension files to SQL Server? Which Transaformation/Source needs to use? 2) What is transaction in SSIS 3) What is Junk Dimension? 4) How can we apply security for username and password for connection string in SSIS 5) How/What is SSIS package deployment