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

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1080

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1189

What is the importance of concurrency control?

1271

How you can get the list of largest tables in a database?

1062

When you should use a low fill factor?

1035

Define cursor locking

1059

What is database replication? What are the different types of replication you can set up in sql server?

1017

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?

1064

Explain the dbcc pintable command when would you use it?

965

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1111

Is it true, that there is no difference between a rule and a check constraint?

1109

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1093

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

952

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1106

Explain a checkpoint?

1085

Un-Answered Questions { SQL Server }

What do you understand by mirroring and mention the advantages of the mirroring?

1112

How to choose all records from the table?

1102

Does a sql server 2005 select statement require a from?

1071

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

How many instances per computer are there in sql server 2000?

1118

Can we use custom code in ssrs?

1163

How to create function with parameter in sql server?

1154

How check triggers in sql server?

1047

how to trace the traffic hitting a sql server? : Sql server database administration

1948

What is update_statistics command?

1121

What are different types of collation sensitivity?

1023

What is service broker? : sql server database administration

1029

What is report server project?

155

How to copy data from one table to another table?

1049

Explain alternate key, candidate key and composite key in sql server?

946

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