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?

1084

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?

1195

What is the importance of concurrency control?

1278

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

1070

When you should use a low fill factor?

1042

Define cursor locking

1061

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

1018

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?

1068

Explain the dbcc pintable command when would you use it?

972

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

1117

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

1116

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?

1102

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?

955

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

1109

Explain a checkpoint?

1089

Un-Answered Questions { SQL Server }

What is the difference between a primary key and a unique key? Are they the same?

1128

What are different types of schemas?

993

Can you always create a cache of a report?

178

How can change procedure in sql server?

1138

What is cdc in sql server?

1046

How do I open a .db file?

1086

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2017

What is Lock table in SQL?

1523

What are sql dirty pages?

1084

How to find Duplicate Records In table?

1076

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1194

What is difference between createstatement and preparedstatement?

1176

How many types of cursor type are there?

1169

What are the tools available in market as an alternative to sql server reporting services?

138

Explain the steps to create and execute a user-defined function in the sql server?

1016

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