SQL/T-SQL

General

• SQL Server Interview Questions 1-25 
• SQL Query to know if a job is running or not
• SQL Query to Get List of All Child Tables for a Given Table
• SQL Query to Get List of All Referenced Tables for a Given Table. 
• Difference Between Truncate & Delete.
• Split comma separated string in sql server 2012
• Difference Between Temporary Table & Table Variable.
• Common Table Expressions (CTE)
• Difference Between Union & Union All 
• Indexed Views
• Filtered Index

Performance Tuning

• Performance Tuning SQL Queries