SQL:
  1. Rate yourself in SQL , SSRS, SSIS and SSAS
  2. Different examples on joins
  3. Display records for alternate gender
  4. Have you used NEWID() function?
  5. Difference between delete and truncate
  6. I have a table with primary key on ID column.  Table contains 1-8 records. If I insert value using identity_insert function,  what will be the next value inserted 9 or 11?
  7. can we create temporary stored procedures?
  8. difference between temporary table and CTE?
  9. difference between clustered and NON clustered index
  10. example of covering index
  11. difference between table variable and Temporary table
  12. what is parameter sniffing?
  13. how data is stored?  different types of pages
  14. Have you used cross apply?
  15. Table 1 - 4 Records , Table 2- 2 Records, Table 3- 0 Records
What will be the output for CROSS JOIN?
  1. What will happen to following SP?
  1. Create SP A as 
BEGIN CREATE #table1 END
  1. Create SP B as
BEGIN exec A END
  1. CREATE SP C as
Begin Exec B END
  1. I have a CTE,  in which I am selecting few records. After the definition I am writing the update CTE statement. What it will update CTE or actual table?
  2. ACID Properties
  3. what is normalisation
  4. difference between stored procedures and functions
  5. types of functions
  6. unique index
  7. PIVOT in SQL
  8. DENSE_RANK() and RANK()
  9. SQL Profiler, which option showing Tuning Advisor
  10. Execution plan
  11. Fragmentation in SQL Server
  12. Difference between table scan, Index scan and Index seek
  13. Cast and rows of the queries
SSRS:
  1. What is data driven subscription and Mail driven subscription?
  2. How to give different background colour to rows being displayed in table?
  3. While you export report in Excel,  I want to display only 3 records in a tab.  how to do it?
  4. While exporting report,  it often happens that you don't see header for a few pages. how to solve that?
  5. What is drill down and drill through reports?
  6. Does sequence affects in cascading parameters?
  7. How to improve performance if report rendering is taking time?
  8. SSRS Config File
  9. What is Subreports?
  10. What is Subscriptions in SSRS
  11. Deployment in SSRS
  12. Difference between table and matrix?   how to add total in table and matrix?
SSIS:

  1. What transformations you have used?
  2. What is use of lookup transformation?
  3. Want to load Delta. Give me 2 to 3 approaches to achieve this?
  4. Transformation in SSIS?
  5. Script task in SSIS
  6. Error handling in SSIS
  7. Difference between Package and Project workflow