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 can we remove orphan records from a table?

948

What do you mean by recursive stored procedure?

905

What structure can you implement for the database to speed up table reads?

1171

What are the acid properties?

958

Explain different types of index?

998

What are user-defined functions (udfs) in sql server?

949

Explain how many normalization forms?

988

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1066

Explain boyce and codd normal form(bcnf)?

900

How important do you consider cursors or while loops for a transactional database?

924

In what version of sql server were synonyms released?

919

What are the aggregate and scalar functions?

1008

What is the need for group functions in sql?

1025

What is the difference between varchar and varchar types?

1015

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

957

Un-Answered Questions { SQL Server }

Why use identity in sql server?

1032

What are the main differences between #temp tables and @table variables and which one is preferred?

1026

How to create nested stored procedure?

973

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

186

How to optimize stored procedures in sql server?

1133

What is correlated subquery in sql server?

1028

How to return the second 5 rows in ms sql server?

1018

what is the system function to get the current user's user id? : Sql server database administration

968

What do you mean by a Composite primary key?

1041

What is normalization according to you and explain its different levels?

914

Why Master database is required?

1068

Can I run multiple instances of sql server 2000 at the same time on one computer?

1041

What is sub-query in sql server? Explain its properties.

1051

What are joins in sql and what are the different types of joins?

976

What is table value parameters (tvp)?

1050

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