Monthly Archives: February 2011

SQL Server Interview Questions and Answers

Posted on February 28, 2011 by randheerparmar

This site contains SQL Server Interview Questions and Answers. Below Links are for all SQL Server components. clicking on link you will get the consolidated all post for interview questions on topic wise.you can also click on labels in side … Continue reading →

Posted in SQL Server Interview Questions and Answers | 3 Comments

SQL Server Interview Questions and Answers: Series 12

Posted on February 27, 2011 by randheerparmar

Question: What is the nesting level of triggers? Answers: A trigger nesting is possible for up to 32 levels. Question: What happens if a transaction is failed in nested transaction, then other outer transactions will execute or not? Answer: If … Continue reading →

Posted in SQL Server Interview Questions and Answers | Leave a comment

SQL Server Interview Questions and Answers : Series 11

Posted on February 27, 2011 by randheerparmar

Question: Can we insert null value in primary column? Answer: Nopes we can’t insert null values in primary column. Question: Can we create clustered index on null value column? Answer: Yes we can create clustered index on null value column … Continue reading →

Posted in SQL Server Interview Questions and Answers | Leave a comment

SSIS Interview Questions and Answers : Series 3

Posted on February 6, 2011 by randheerparmar

Question: How to create the deployment utility? Answer:Deployment utility can be created by right click on solution explorer setting create deployment utility to true.   Question: How to deploy the packages SSIS? Answer: When you build the package by clicking … Continue reading →

Posted in SSIS Interview Questions and Answers | Leave a comment

SSIS interview Questions and Answers : Series 2

Posted on February 6, 2011 by randheerparmar

Question: What is event handler Tab in Design window? Answer: In event handlers table error handling of package can be done. It has different functions which executes when there any event occurs in package such as task failed, task execution … Continue reading →

Posted in SSIS Interview Questions and Answers | Leave a comment

SSIS interview Questions and Answers : Series 1

Posted on February 6, 2011 by randheerparmar

Question: What is SSIS package? Answer: SSIS package is an entity which performs ETL task in SSIS. Extract the data transform it create flow and load it in destination. Question: What is the control flow Task? Answer: Control flow task … Continue reading →

Posted in SSIS Interview Questions and Answers | Leave a comment

SSIS Interview Questions and Answers

Posted on February 6, 2011 by randheerparmar

This post contain the interview questions for sql server inegration services. I am posting these questions in multiple series.I have provided the answers but read other study material or books on line to get more conceptual knowledge.   SSIS Interview … Continue reading →

Posted in SSIS Interview Questions and Answers | Leave a comment