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?

937

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

951

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

938

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

895

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

1093

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?

1130

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?

998

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

1045

What is a fill factor?

1078

How can you find out which stored procedures are recompiling?

915

What is a transaction and why is it important?

1082

Explain a differential backup?

1001

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

949

What are the advantages dts has over bcp?

997

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

982

Un-Answered Questions { SQL Server }

where the connection string store in the database

2064

How to create prepared statements using odbc_prepare()?

1059

Do you know what is difference between index seek vs. Index scan?

949

How connect excel to sql server?

988

can SSRS reports Cache results?

147

What do you understand by replication in sql server? Mention the different types of replication in sql server.

939

Can sub report data source be different from that of the parent report?

143

Describe and explain about SQL native client?

1101

What is hot add cpu in sql server 2008?

922

What is trace flag in sql server?

1016

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1031

What is clustered index

998

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1002

What is BCP? When does it used in sql server 2012?

1052

List few advantages of stored procedure.

981

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