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

What is the exact numeric data type in sql?

1056

Which table keeps the locking information?

984

How many types of cursor type are there?

1162

How can you list all the columns in a database?

969

What is the difference between deallocate cursor and close cursor?

1328

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1027

Using the customer, and order table in northwind database, please write a query to produce xml?

1113

What is mapping schema?

1068

What is the downside of using udf?

1158

Your table has a large character field there are queries that use this field in their search clause what should you do?

923

Where can you add custom error messages to sql server?

1156

What is the primary use of the model database?

1128

what is the difference between openrowset and openquery?

1153

Why and when do stored procedure recompile?

1026

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

1029

Un-Answered Questions { SQL Server }

Can you explain full-text query in sql server?

1057

Explain unique key in sql server?

1049

What are the underflow and overflow behaviors on float literals?

1164

What are scalar functions in sql?

1203

How to create median function?

172

Why truncate is ddl?

1133

Why do we partition data?

1079

Describe and explain about SQL native client?

1153

Mention the different authentication modes in sql server.

1101

What are various ways to enhance the ssrs report?

1032

How do you handle datasets larger than 50 gb?

164

Explain what is dbcc?

1064

Can an automatic recovery be initiated by a user?

1066

Define candidate key, alternate key, and composite key.

966

What programming language would you use to create embedded functions in ssrs?

191

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