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?

921

Can you index views?

858

Does view occupy space?

890

What is difference between materialized view and view?

885

How do you create a clustered index?

1015

How do you drop an index?

872

How does clustered and non clustered index work?

854

What are the types of indexing?

1036

What is an index in a database?

930

What is the need for indexing?

895

What are the lambda triggers?

865

Can you leave a union at any time?

1016

Does union all remove duplicates?

1022

What does it mean to be in union?

880

Why union all is faster than union?

870

Un-Answered Questions { SQL Server }

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1075

Why do we need normalization?

882

Is null vs coalesce?

829

what's the difference between a primary key and a unique key? : Sql server database administration

902

what is a check constraint?

1048

What is normalization of database?

1032

What is a field name?

924

How can we call UDF(User Define Function) using C# code in ASP.net ?

6824

What is 1nf 2nf?

972

List out the different types of locks available in sql server?

940

How to convert character strings into numeric values?

1051

What is sql collation?

1146

How network traffic be reduced by using the stored procedure?

1055

What causes index fragmentation?

950

Can you insert NULL in unique column?

1109

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