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 encryption security is available in sql azure?

101

Explain security with sql azure?

186

Can I use sql azure as a backup with log shipping or database mirroring?

156

What is it’s similarity with sql server?

160

What are horizontal and vertical scaling?

170

What are rest-style architecture's?

170

What is the data tier application?

169

How do you handle datasets larger than 50 gb?

162

What is the difference in accessing db between sql server vs sql azure?

174

How many databases can we create in a single server?

207

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

What is sql azure database?

206

How do you migrate data from mssql server to azure?

165

Where actually sql azure database is hosted?

163

How many servers can we create in a single subscription?

162

Un-Answered Questions { SQL Server }

What is a primary key?

950

What do you mean by tablesample?

1074

How to disable a login name in ms sql server?

1129

How can you check the version of sql server?

1095

When does a workload on SQL Azure get throttled?

131

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1032

Where can you find the error log information? : sql server database administration

1023

Tell me extended events in sql server 2008?

992

How to verify a login name with sqlcmd tool?

1214

What is the use of =,==,=== operators?

1005

What are Spatial data types in SQL Server 2008

1014

What is the use of partition by in sql server?

931

Write the syntax for stuff function in an sql server?

1024

What are the advantages of user defined function?

980

What is the xml datatype?

1053

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