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

Can we do dml on views?

949

Can you index views?

891

Does view occupy space?

934

What is difference between materialized view and view?

905

How do you create a clustered index?

1044

How do you drop an index?

916

How does clustered and non clustered index work?

919

What are the types of indexing?

1075

What is an index in a database?

974

What is the need for indexing?

943

What are the lambda triggers?

894

Can you leave a union at any time?

1055

Does union all remove duplicates?

1058

What does it mean to be in union?

930

Why union all is faster than union?

907

Un-Answered Questions { SQL Server }

What is a raid and what are different types of raid configurations?

1261

Is it possible in sql table to have more than one foreign key?

1025

How does normalization work?

913

How to declare and use cursor variables?

1158

What is an sql server agent?

1056

Write an sql query for deleting duplicate rows?

995

What is a join in sql?

1079

What is the maximum size of a dimension? : sql server analysis services, ssas

1036

Other than truncate statement, which other command can by-pass the trigger on the tables?

1128

Explain boyce and codd normal form(bcnf)?

934

What is the use of stored procedure?

933

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1068

What are Row versions of DataRow?

1016

What do you mean by recursive stored procedure?

941

What is a covering index?

980

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