Tag Archives: SQL Server

MSBI Interview Question’s:- Part 1

We have come up with few real-time questions asked to one of the fresher candidate during MSBI(SSIS, SSAS and SSRS) interview questions if you are one of those who is seeking for the same then below questions and answers will surely … Continue reading

Posted in MSBI, MSBI Interview Question, Uncategorized | Tagged , , , , , | Leave a comment

SQL Server interview questions: -How to delete duplicate records which does not have primary key?

Let me first explain what this question is all about. Let’s say you have table which has names as shown in the below figure. Now in the names table you have duplicate records (ex. Shiv) and this table does not … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

11 Important Database designing rules which I follow

Introduction Before you start reading this article let me confirm that I am not a guru in database designing. The below 11 points which are listed are points which I have learnt via projects, my own experiences and my own … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

SQL Server interview questions: – What is architecture of Notification Services?

This is the SQL Server interview questions which more of Database administrator (DBA) oriented. Have a look before going for interview. So one can start answering this question as follows. Detail sections in SQL notification services:- Notification Service application: – … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment

SQL Server interview questions: – Show how to convert a Table Data in to XML format in SQL Server?

This is one of the typical  SQL Server interview questions and also the favorable question of the  interviewers. The interviewers ask this question to check your skills on converting the table data in to XML format but many of your … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment