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

Define a cross join?

1006

Explain an incremental backup?

994

How will you know when statistics on a table are obsolete?

1074

How you can find out if an index is useful to the optimizer?

933

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

979

What are statistics?

991

Can a unique index be created on a column, which contains null?

915

How can a database be repaired?

986

What are the differences between triggers and stored procedures?

1060

Where are full-text indexes stored?

985

Write a sql query to delete duplicate records from a table called table1

1026

Which data type columns are the best candidates for full-text indexing?

963

What stored procedure can you use to display the current processes?

884

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 database replication?

1132

Un-Answered Questions { SQL Server }

How to create a scrollable cursor with the scroll option?

993

What is relationship? What number of sorts of relationship are there?

1131

What is user defined datatypes and when you should go for them?

1014

how to determine the service pack currently installed on sql server? : Sql server database administration

957

Explain Capacity planning to create a database? and how to monitor it?

4198

How can you set the threshold at which sql server will generate keysets asynchronously?

981

What is the filtered index?

1048

What is msdb database? : SQL Server Architecture

1127

Your table has a large character field there are queries that use this field in their search clause what should you do?

879

Why are sql functions used?

1113

Describe in brief sql server monitoring ways.

1048

Differentiate between a local and a global temporary table?

950

What is row-level compre?

993

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

1007

How many partitions a clustered index has by default in sql server 2012?

1084

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