Tag Archives: SQL

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: – 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

SQL Server interview questions: – Can you mention two types of indexes and explain them?

This is the SQL Server interview questions most asked during the interview so do revise before you go for the interview. There are basically two types of indexes:- Clustered Indexes. Non-Clustered Indexes. Every thing is same for both the indexes … Continue reading

Posted in Clustered Indexes, Csharp interview questions, Non-Clustered Indexes, programming interview questions, SQL Server, SQL Server interview questions | Tagged , , , , , , , , | 1 Comment

SQL Server interview questions: – Explain publisher, distributor and subscriber in “Replication”?

This is the most expected asked SQL Server interview questions during the interview by the interviewer. Publisher is the one who owns the database and is the main source for data. Publisher identifies what data should be distributed across. Distributor … Continue reading

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

SQL Server interview questions: – What are different types of relationship existing in database designing?

This is one of the most favorite SQL Server interview questions asked by the interviewer during the interview. We have tried to keep answer as simple as we can. So starts the answer as, basically there are three major relationship … Continue reading

Posted in .net, .NET and C# training, .Net Interview Questions, .NET interview questions and answers, Csharp interview questions, database, programming interview questions, SQL Server, sql sever interview questions and answers | Tagged , , , , , , , , , , | Leave a comment

SQL Server interview questions – Explian Referential Integrity in SQL Server?

This is one the typical SQL interview questions and also the favorable question of the interviewers, which has been asked in most of the .NET interviews. Referential Integrity: – Referential Integrity is a DataBase concept that ensures the relationship between … Continue reading

Posted in .NET and C# interview questions and answers, .NET and C# training, .Net Interview Questions, Csharp interview questions, integrity, programming interview questions, SQL Server, SQL Server interview questions and answers | Tagged , , , , , , , | 1 Comment

LINQ interview questions: -Elaborate differentiation between LINQ to SQL and Entity framework?

Following is the LINQ interview questions asked in an interview: – • LINQ to SQL is good for rapid development with SQL Server. EF is for enterprise scenarios and works with SQL server as well as other databases. • LINQ … Continue reading

Posted in .NET and C# training, .Net Interview Questions, Csharp interview questions, LINQ interview questions, programming interview questions | Tagged , , , , , , , | Leave a comment