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?

1059

What types of replication are supported in sql server?

1063

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?

1122

How to get nth highest salary from employee table.

1163

How would you add a section to a table?

1044

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

1034

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?

403

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 }

Do you know the isolation level that sql server support?

960

How to defragment indexes with alter index ... Reorganize?

1088

How to execute the cursor queries with "open" statements?

1180

What is indexed view? How to create it?

1009

What are “unrepeatable reads”?

1234

What happens if strings are casted into wrong code pages in ms sql server?

1113

What is the stuff?

1001

Differentiate between sql temp table vs table variable?

881

Give an example of SQL injection attack ?

1006

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

What is cursor in ms sql server?

1147

How to fine-tune reports?

268

Why use identity in sql server?

1103

Explain difference between cross join and full outer join?

1005

What is the difference between indexing and hashing?

1169

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