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 a result set object returned by odbc_exec()?

1079

What is a result set object returned by mssql_query()?

1230

Explain what are the authentication modes in sql server?

1073

How to use linked server?

1274

Explain what is cte (common table expression)?

1191

Explain features and concepts of analysis services?

1024

Do you know what is user defined datatypes and when you should go for them?

1014

Do you know what is difference between index seek vs. Index scan?

1008

Can we use custom code in ssrs?

1169

Explain what are the restrictions while creating batches in sql server?

1116

Explain about sql server login?

1140

Explain about builtinadministrator?

1117

Do you know what are different types of replication in sql server?

1156

Tell me what is use of except clause? How it differs from not in clause?

1003

Can you please differentiate between a primary key and a unique key?

1053

Un-Answered Questions { SQL Server }

what protocol both networks use? : Sql server database administration

1019

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

951

Can you explain full-text query in sql server?

1061

What is the use of set nocount on/off statement?

1145

What is triggers in ms sql server?

1184

What are the advantages of using a stored procedure?

1065

How to find the second highest salary of an employee?

1228

How to modify the underlying query of an existing view?

1033

What are the different authentication modes in sql server? How can it be changed?

1142

What are filegroups in sql server?

1106

How to find the list of fixed hard drive and free space on server?

1286

How to replace the Query Result 'Null Value' with a text ?

1099

System variable and temporary variables

2302

if no size is defined while creating the database, what size will the database have? : Sql server administration

1061

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1089

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