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

Which autogrowth database setting is good?

1097

What types of replication are supported in sql server?

1121

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

999

What is not null constraint?

1183

How to get nth highest salary from employee table.

1213

How would you add a section to a table?

1115

What do you mean by stored techniques? How would we use it?

1086

Tell me something about security and sql azure?

116

How many replicas are maintained for each sql azure db?

124

What is federation member?

116

How to identify current user in ssrs report?

409

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

176

Explain can you implement data mining in ssrs?

161

How to change parameter value inside the report?

169

What is the rdl file?

141

Un-Answered Questions { SQL Server }

How do I view a stored procedure in sql server?

1034

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1112

What is logon trigger?

1166

Are all views updatable ?

1205

What are three major types of constraints?

1185

What are cascading parameters in ssrs reports?

236

Why do you want to join software field as you have done your BE in Electronics?

2200

How to write a query with a left outer join in ms sql server?

1033

Explain intellisense for query editing

1076

What is reference section?

1061

What is the difference between locking and multi-versioning?

1043

How to delete duplicate rows?

1040

What stored by the model?

1142

Does full backup break log chain?

1018

Which table keeps information about stored procedures?

987

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