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?

1049

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

1126

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

985

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

1041

What are statistics?

1050

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

966

How can a database be repaired?

1032

What are the differences between triggers and stored procedures?

1114

Where are full-text indexes stored?

1036

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

1085

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

1022

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

939

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?

1087

What is database replication?

1207

Un-Answered Questions { SQL Server }

Where views are stored in sql server?

1026

What is primary key and example?

994

To which devices can a backup be created and where should these devices be located? : sql server management studio

1099

What is snapshot report?

172

what are different types of backups available in sql server? : Sql server database administration

982

Write the SQL query to drop, truncate and delete table.

1026

What is the difference between writing data to mirrored drives versus raid5 drives

985

Give the query of getting last two records from the table in SQL SERVER?

1008

What is the usage of the sign function?

1190

What structure can you implement for the database to speed up table reads?

1231

what are the different types of SSRS reports?

160

Define Joins?

1073

Give main differences between "Truncate" and "Delete".

1148

What is bit data type? What's the information that can be stored inside a bit column?

965

What is nolock hint in sql server 2008

1178

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