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()?

1056

What is the difference between local and global temporary tables?

1083

What is bcp? When does it use?

881

What is the osql utility?

920

Explain the steps needed to create a scheduled job?

886

What are the types of joins in sql?

1066

What are orphan records?

894

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

998

List all the types of user-defined functions?

1007

Why use “nolock” in sql server?

995

Explain primary key in sql server?

978

What is the filtered index?

990

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

864

How will you go about resolving deadlocks?

923

What is the difference between osql and query analyzer?

944

Un-Answered Questions { SQL Server }

What are the tools available in market as an alternative to sql server reporting services?

121

What is best institute to Learn DotNET And SQL in chennai?

2124

How can I check if a view exists in a sql server database?

990

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1147

Can you use order by when defining a view?

923

What are transactions and its controls?

1013

What is snapshot replication?

1008

can an automatic recovery be initiated by a user? : Sql server administration

907

What the different components of Replication and what is their use?

1022

What is an expensive query?

891

When to use Inner join & when to use subquery?

1094

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

894

How do I port a number to sql server?

989

Explain how dts is used to extract, transform and consolidate data?

947

What is the osql utility?

920

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