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?

993

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

1000

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

990

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

964

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

1155

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?

1193

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?

1061

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

1101

What is a fill factor?

1141

How can you find out which stored procedures are recompiling?

953

What is a transaction and why is it important?

1167

Explain a differential backup?

1065

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

1020

What are the advantages dts has over bcp?

1051

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

1040

Un-Answered Questions { SQL Server }

Explain ranking functions?

1099

where the connection string store in the database

2124

What is exporting utility?

1090

Describe different Processing Modes offered by SSRS?

256

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

1027

How to use the inserted and deleted pseudo tables?

1006

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1201

Explain syntax for dropping triggers?

969

What is onf in normalization form?

1111

What are the diifferences between the ms sql server vs mysql?

1240

‘Order by’ is not allowed in a view how can you sort information from a view?

1123

What is clustered index

1061

Why use “pivot” in sql server?

1183

Explain how many normalization forms?

1077

Do you know spatial data types - geometry and geography in sql server 2008?

1092

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