In this article we will explain stateless and stateful load balancing in SQL Server. For more articles and videos visit us on http://www.questpond.com/

In this article we will explain about Fragmantation in SQL Server. For articles and videos visit us on http://www.questpond.com/

In this article we will explain about Clustered index and Non-Clustered Index. For more articles and videos visit us on www.questpond.com

In this article we will explain publisher, distributor and subscriber in “Replication”. For more articles and videos visit us on www.questpond.com

In this aricle we will explain different types of relationship existing in database designing.For more articles and videos visit us on www.questpond.com

This SQL Server interview questions is more of practical oriented. Below is the code to connect SQL Server, then we will try to understand the same in a more detailed manner.

Referential Integrity is a DataBase concept that ensures the relationship between tables remainsconsistent, where one table has a foreign key reference to the other table which is declared asprimary key.

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.

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 developer friends fails t

This is one of the most favorite SQL Server interview questions asked by the interviewer.

A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a transaction:

There are three types of replication supported by SQL SERVER:-

This is one of the most typical questions asked in most of the interviews and is the favorable question of interviewers to check your skill on SQL.

There are basically two ways (methods) in order to back-up SQL Server Database and Restore database.