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

Can you force a query to use a specific index?

985

How you can get a list of all the table constraints in a database?

997

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

980

Write a sql query to sort on different column name according to the parameters passed in the function?

957

What will happen if a column containing char type data is changed to the nchar data type?

1147

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1185

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1051

How you can move data or databases between servers and databases in sql server?

1098

What is a fill factor?

1137

How can you find out which stored procedures are recompiling?

948

What is a transaction and why is it important?

1159

Explain a differential backup?

1058

between cast and convert which function would you prefer and why?

1010

What are the advantages dts has over bcp?

1047

What does it mean if @@cursor_row returns a negative number?

1032

Un-Answered Questions { SQL Server }

What is use of except clause?

1138

Can you use order by when defining a view?

1019

What are the types of subscriptions in SQL Server replication?

1100

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107

Explain different forms of normalization?

1001

What is a dataset and what are the different types of datasets?

141

what are the new features in SSRS?

145

How to make a remote connection in a database?

1019

Do you know what is fill factor and pad index?

1042

What is report subscription?

132

What is the cartesian product of table?

1060

What is #temp and @table variable in SQL server?

1140

What are points to remember while using the fillfactor argument?

1014

Difference between Inner vs outer joins?

984

What is snapshot report?

172

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