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

How to find index size for each index on table?

1005

What is database mirroring?

1123

What are dml triggers and types of dml triggers?

983

What is difference between line feed ( ) and carriage return ( )?

911

What languages bi uses to achieve the goal?

1003

What is checkpoint process in the sql server?

1039

What is raiseerror? What is raiseerror?

1147

What is the difference between varchar and varchar(max) datatypes?

1079

What is the difference between seek predicate and predicate?

1064

What is the correct order of the logical query processing phases?

938

Where in ms sql server is ’100’ equal to ‘0’?

1094

Explain iaas, paas and saas?

Explain the Ways to improve the performance of a sql azure database?

What are parameterized reports?

204

Differentiate sql server reporting services vs. Crystal reports?

203

Un-Answered Questions { SQL Server }

What is the difference between deallocate cursor and close cursor?

1266

What is cursors?

1193

How do you run a trace?

908

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1083

What is data source in connection string?

914

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1069

How to concatenate two strings in SQL Server.

1152

What is raid? : SQL Server Architecture

1184

What is change data capture (cdc) in sql server 2008?

1030

How to round a numeric value to a specific precision?

1076

Does a sql server 2005 select statement require a from?

1025

What does it mean to normalize a database and why would you do it?

984

Explain the Ways to improve the performance of a sql azure database?

Explain what is use of dbcc commands?

1062

List out what other servers you can use with ssrs?

139

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