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

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

Explain why variables called the most powerful component of ssis?

1097

Explain the use of containers in ssis and also their types?

968

What is precedence constraint?

983

Why variables called the most powerful component of ssis?

1079

Explain error handling in ssis?

1023

What are the types of containers in ssis?

1171

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

980

Explain the use of containers in ssis?

965

Why is the need for data conversion transformations?

1067

What is conditional split?

1076

Can we add our custom code in ssis?

988

Explain the difference between control flow and data flow?

994

What are the purposes and advantages stored procedure?

959

Determine when to use stored procedure to complete sql server tasks?

1054

Un-Answered Questions { SQL Server }

How to get a list of columns in a view using "sys.columns" in ms sql server?

994

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

988

What are the Advantages of using CTE in sql server?

1119

Is sql server 2016 free?

935

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

951

How to download and install microsoft .net framework version 2.0?

1139

What is subquery explain with example?

1061

What is store procedure? How do they work? When do you use?

942

How to create sub reports?

242

What are scalar functions in sql?

1144

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1217

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2093

What is the use of sign function?

1124

What are the disadvantages of merge replication?

1424

What are the new features in sql server 2016?

967

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