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?

1084

Explain an incremental backup?

1052

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

1131

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

987

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

1050

What are statistics?

1054

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

970

How can a database be repaired?

1034

What are the differences between triggers and stored procedures?

1119

Where are full-text indexes stored?

1040

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

1090

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

1026

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

949

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?

1099

What is database replication?

1212

Un-Answered Questions { SQL Server }

Give an example of why you would want to denormalize a database

1035

what is sql server? : Sql server database administration

1046

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2416

Explain can you implement data mining in ssrs?

161

How you can get a list of all the table constraints in a database? : Sql server administration

1098

Can we call future method from trigger?

1005

how would you store your query in an SSRS report or a Database server?

167

what is a live lock? : Sql server database administration

1021

What is built-in function?

1064

Explain DBCC?

1018

What is oltp (online transaction processing)?

1061

What is dynamic cursor in SQL SERVER?

1141

Explain try...catch with sql server?

1072

What are transactions and its controls?

1109

What is the difference between DATETIME2 and DATETIME?

1131

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