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?

1055

What types of replication are supported in sql server?

1061

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?

944

What is not null constraint?

1113

How to get nth highest salary from employee table.

1163

How would you add a section to a table?

1028

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

1023

Tell me something about security and sql azure?

114

How many replicas are maintained for each sql azure db?

124

What is federation member?

116

How to identify current user in ssrs report?

401

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

169

Explain can you implement data mining in ssrs?

158

How to change parameter value inside the report?

164

What is the rdl file?

138

Un-Answered Questions { SQL Server }

What is the difference between a function and a stored procedure?

1065

How to view existing indexes on an given table using sys.indexes?

1088

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1136

How do you improve the performance of a SQL Azure Database?

137

What is the Control Flow in SSIS

1087

Write a SQL query to make a column as unique?

1030

What is the contrast between sql and mysql?

1107

Mention the differences between having and where clause.

1055

What is difference between global temporary tables and local temporary tables?

1229

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

do you know how to configure db2 side of the application? : Sql server database administration

1039

How to delete a database in ms sql server?

1225

How do I get to sql server configuration manager?

1006

What is the use of sql profiler in sql server 2012?

886

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

977

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