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?

949

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

958

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

948

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

911

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

1110

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?

1143

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?

1006

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

1054

What is a fill factor?

1091

How can you find out which stored procedures are recompiling?

920

What is a transaction and why is it important?

1093

Explain a differential backup?

1014

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

962

What are the advantages dts has over bcp?

1006

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

997

Un-Answered Questions { SQL Server }

What are dml (data manipulation language) statements in ms sql server?

990

Explain index in sql server?

1021

How many full-text indexes can a table have?

977

Explain the difference between control flow and data flow?

1007

What are the different subsets of sql?

1554

Can we write a distributed query and get some data which is located on other server and oracle database?

1234

What is acid properties?

1109

Can we perform backup restore operation on tempdb? : sql server database administration

1002

Write down the syntax and an example for create, rename and delete index?

990

Is INSTEAD OF trigger directly applicable to Table ?

1021

What is sql view?

1047

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

1075

what is a self join? : Sql server database administration

1047

How can I change procedure name in sql server?

1055

How to insert multiple rows with a subquery?

1140

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