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

Mention the differences between local and global temporary tables.

966

What do you understand by check constraint in sql server?

902

What is the tcp/ip port on which sql server runs?

1082

What do you understand by intent locks?

964

Explain log shipping and mention its advantages.

998

Explain log shipping?

972

What do you understand by the analysis services in sql server?

908

What are the steps you must follow to hide sql server instances?

944

What are the advantages of mirroring?

953

What do you understand by user-defined function in the sql server?

916

What are the differences between having and where clause.

934

What are the options which must be set to allow the usage of optimistic models?

922

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

951

Mention the command used to rename the database.

960

Mention the differences between sql server and mysql.

965

Un-Answered Questions { SQL Server }

How to rebuild the master database?

1027

Tell me what is use of except clause? How it differs from not in clause?

914

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1030

How to locate and take substrings with charindex() and substring() functions?

957

What is the difference between mysql and mysqli?

1114

Name and describe few console utilities for ssrs?

280

What is primary key, unique key, and foreign key?

926

How to create database with physical files specified in ms sql server?

967

Why do we use trigger?

927

How to Insert multiple rows with a single insert statement?

1020

What is a non equi join?

923

What are the properties of the transactions?

1068

What is self contained scalar sub query?

937

What are Spatial data types in SQL Server 2008

978

What is a covered index?

898

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