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 is the difference between coalesce() & isnull()?

1120

What is the difference between local and global temporary tables?

1133

What is bcp? When does it use?

935

What is the osql utility?

950

Explain the steps needed to create a scheduled job?

917

What are the types of joins in sql?

1111

What are orphan records?

924

What have included columns when we talk about sql server indexing?

1028

List all the types of user-defined functions?

1085

Why use “nolock” in sql server?

1049

Explain primary key in sql server?

1008

What is the filtered index?

1042

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

894

How will you go about resolving deadlocks?

964

What is the difference between osql and query analyzer?

983

Un-Answered Questions { SQL Server }

What is SQL Azure?

105

How can you set the threshold at which sql server will generate keysets asynchronously?

977

Do you know what are acid properties of transaction?

948

What are the different types of columns types constraints in the sql server?

1073

What is the difference between varchar and varchar(max) datatypes?

1062

What is a unique key constraint?

1022

What are the different types of triggers in SQL SERVER?

1120

How to create view in stored procedure sql server?

1009

What is change data capture (cdc) in sql server 2008?

1018

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1114

What is normalization process?

1161

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1207

Can sub report data source be different from that of the parent report?

142

How do I create a trace in sql server?

1023

What are binary string data types in ms sql server?

1273

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