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?

1034

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?

1135

What is the importance of concurrency control?

1220

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

1007

When you should use a low fill factor?

990

Define cursor locking

996

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

956

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?

1003

Explain the dbcc pintable command when would you use it?

911

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

1051

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

1048

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?

1033

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?

904

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

1038

Explain a checkpoint?

1026

Un-Answered Questions { SQL Server }

What is role playing dimension with two examples? : sql server analysis services, ssas

1000

What are sql dirty pages?

1015

Can you tell me about the concept of ER diagrams?

1063

How can you append an identity column to a temporary table?

944

What is the command to change the recovery model?

1040

What is the purpose of indexing?

1041

How do I find the port number for sql server?

969

What is the use of group by clause?

938

What are the properties of the transaction?

1000

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

929

When is the use of update_statistics command?

997

How to loop through the result set with @@fetch_status?

1339

What is the difference between createstatement and preparedstatement?

936

What is ms sql server triggers?

1007

What is store procedure? When do you use?

926

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