SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What are xml indexes?

900

What is the openxml statement in sql server?

1026

Explain indexed view?

1 1379

What is for xml in sql server?

1004

How to call stored procedure using http soap?

1022

Can you explain what is indexed view? How to create it?

861

Explain what are partitioned views and distributed partitioned views?

904

Do you know what are the restrictions that views have to follow?

1036

What are secondary xml indexes?

995

What are the disadvantages of merge replication?

1333

What is replication and database mirroring?

1007

What is shared lock?

848

Explain the advantages of merge replication?

916

Explain hostprotectionattribute in sql server 2005?

972

What is exclusive locks?

930

Un-Answered Questions { SQL Server }

Explain error and transaction handling in sql server?

967

What do you understand by recursive stored procedure?

892

Can a trigger be created on a view?

912

What different steps will a sql server developer take to secure sql server?

948

What are the results of running this script?

878

What is a recursive stored procedure in sql server?

1108

Which Model uses the SET concept

950

What is the difference between writing data to mirrored drives versus raid5 drives

882

How do I edit a stored procedure in sql server?

896

What is 2nf normalization form?

1077

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

Explain the difference between HTTP and HTTPS in database?

990

Explain nested join?

935

What is an example of a primary key?

932

How many types of stored procedures are there in sql server?

971

For More Un-Answered { SQL Server } Questions Click Here