SQL Interview Questions

• Filtered Index
• SQL Server : SQL Query to get schema of columns in a SQL table
• SQL Server : What is calculated or computed column in SQL
• SQL Server : User Defined Functions in SQL
• SQL Server : Identity vs UniqueIdentifier columns
• How can a column in SQL table made as Identifier column
• What is use of Show Server Trace option in SQL Query Analyzer
• SQL Server : How to create linked server
• How to retrieve information from SQL table in Linked SQL Server
• FOR XML Clause - SQL SELECT statement
• SQL SERVER – Get Current TimeZone Name in SQL Server
• Escape Single Quotes in SQL
• Conditional Split in SSIS
• What is default value of DelayValidation property in SSIS
• What does DelayValidation property mean in SSIS
• What are different task colour shown when SSIS package exceutes ? What
• What are various tabs in SSIS Package Design window ?
• How XML can be stored in relational database ?
• SQL Questions : What is normalization ?
• SSIS : What is difference between Control Flow and Data Flow in SSIS ?
• What is SSRS ?
• Quick SQL Interview Questions
• Types of Joins in SQL