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 are the new security features added in sql server 2012? : sql server security

1110

Name three of the features managed by the surface area configuration tool? : sql server security

1034

What is sql injection and why is it a problem? : sql server security

1192

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1108

What are the extra roles available in msdb? : sql server security

1184

What is the new security features added in sql server 2014? : sql server security

1050

How can sql server instances be hidden? : sql server security

1218

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

1033

What are the fixed server level roles? : sql server security

1227

How can sql injection be stopped? : sql server security

1107

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1116

What are the database roles? : sql server security

1279

How to resolve the orphan use problem? : sql server security

1076

How to recover from sql injection? : sql server security

1069

What is the new security features added in sql server 2016? : sql server security

1166

Un-Answered Questions { SQL Server }

Why would you call update statistics?

1078

What do you mean by cardinality?

945

what is create database syntax? : Sql server database administration

1169

How much is a sql server license?

1012

What is the downside of using udf?

1167

What is field with example?

978

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1173

What is the difference between a view and a stored procedure?

1092

What is difference between Datepart() and Datename() in SqlServer?

1265

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1078

how to control the amount of free space in your index pages? : Sql server database administration

1087

Do you know what is normalization of database? What are its benefits?

1208

What are statistics?

1054

What is sql server replication? : sql server replication

1041

How to reaname table name without using sp_Rename in sql server..?

1041

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