Category Archives: SQL Server

23 important SQL Server interview questions on Database concepts

23 important SQL Server interview questions on Database concepts This section will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the … Continue reading

Posted in .NET and C# interview questions and answers, .NET and C# training, .Net Interview Questions, C# interview questions, Csharp interview questions, Interview question, programming interview questions, SQL Server, SQL server training | 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 .net, .Net Interview Questions, C# interview questions, Csharp interview questions, programming interview questions, SQL Server | Tagged , , , , , | Leave a comment

ASP.NET MVC (Model view controller) interview questions and answers: – What is the latest version of MVC and what is the difference between each version?

In case you are new to MVC start learning by click on this video learn MVC step by step. When this note was written, four versions where released of MVC. MVC 1 , MVC 2, MVC 3 and MVC 4. … Continue reading

Posted in .Net Interview Questions, ASP.NET, C# interview questions, Csharp interview questions, MVC (Model view controller), MVC interview questions and answers, programming interview questions, SQL Server | Tagged , , , , , , , | 1 Comment

.NET and c# Interview Question and answers: – If we want to update interface with new methods, what is the best practice?

This is an awesome c# interview question. Kudos to the interviewer who has asked this c# question and double kudos to the candidate if he answers this c# question. The biggest use of interface is to ensure that strict CONTRACT … Continue reading

Posted in .NET and C# training, .Net Interview Questions, C# and .NET interview questions and answers, C# interview questions, Csharp interview questions, programming interview questions, SQL Server | 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 .net, .NET and C# training, .Net Interview Questions, Csharp interview questions, Database designing, programming interview questions, SQL Server | Tagged , , , , , | Leave a comment

SQL Server interview question:- Explain SSIS, SSAS and SSRS?

All these 3 things are related to Business intelligence. Business intelligence is all about making meaning of your data, forecasting using that data, making more business sense from the data. In order to do the same we first need to … Continue reading

Posted in .NET and C# training, .Net Interview Questions, Csharp interview questions, programming interview questions, SQL Server, SQL Server interview questions and answers, SQL training, SSAS, SSIS, SSRS | Tagged , , , , , , , | Leave a comment

SQL Server interview questions: – What are the essential components of SQL Server Service broker?

An SQL Server interview questions asked in the interview. So do read the following answer before going for an interview. Following are the essential components of SQL Server:- End-Points The endpoints can be two applications running on different servers or instances, … Continue reading

Posted in Csharp interview questions, programming interview questions, SQL Server, SQL Server interview questions, SQL Server Service broker, SQL training | 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 architecture of Notification Services, Csharp interview questions, programming interview questions, SQL Server, SQL Server interview questions and answers, SQL training | Tagged , , , , , , , , | Leave a comment

SQL Server interview questions: – Elaborate stateless and stateful load balancing?

Following way you can answer this SQL Server interview questions. Stateless load balancer Stateless load balancer uses the hashing algorithm. It takes packet from the client and selects fields from the packet to be hashed. For instance from each client … Continue reading

Posted in Csharp interview questions, programming interview questions, SQL Server, SQL Server interview questions and answers, SQL training, stateful load balancing, stateless | Tagged , , , , , , , | Leave a comment

SQL Server interview questions: – Mention Fragmentation in SQL Server?

This is the SQL Server interview questions which are asked during the interview not so frequent. But still go through it once before going for the interview. Speed issues occur because of two major things Fragmentation. Splits. Splits have been … Continue reading

Posted in Csharp interview questions, Fragmentation in SQL Server, programming interview questions, SQL Server, SQL Server interview questions, SQL training | Tagged , , , , , | 2 Comments