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?

1040

Explain an incremental backup?

1008

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

1083

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

941

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

996

What are statistics?

1007

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

922

How can a database be repaired?

997

What are the differences between triggers and stored procedures?

1071

Where are full-text indexes stored?

997

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

1041

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

972

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

899

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?

1040

What is database replication?

1152

Un-Answered Questions { SQL Server }

Why do we use stored procedures in sql server?

949

What is RMS migrations?

2136

What is a Join and explain its types?

1106

What is the new security features added in sql server 2014? : sql server security

1008

How to write a query with a full outer join in ms sql server?

1086

How are the unique and primary key constraints different?

1078

Explain filtered indexes benefits?

1004

What is an index. What are the types?

1093

How to see the event list of an existing trigger using sys.trigger_events?

1077

Explain what is dbcc?

1015

your distribution database is full what will u do

2178

Explain what is the function of sql server agent windows service?

1001

Define cross join in sql server joins?

1028

What is the index requirement in SQL Azure?

What are system databases into sql server (2005/2008)?

1004

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