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?

172

What are rest-style architecture's?

174

What is the data tier application?

169

How do you handle datasets larger than 50 gb?

164

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

174

How many databases can we create in a single server?

209

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

187

What is sql azure database?

206

How do you migrate data from mssql server to azure?

167

Where actually sql azure database is hosted?

167

How many servers can we create in a single subscription?

162

Un-Answered Questions { SQL Server }

How do you delete a data source?

1052

What is normalization process?

1244

What are the key configuration files for sql server reporting services ?

171

What is index fragmentation in ms sql server?

1152

What is the name of reporting services config file and what’s it’s used for?

153

What is meant by Active-Passive and Active-Active clustering setup?

1279

How to create median function?

172

What are different types of views?

990

What is single-user mode?

986

What is indexed view? How to create it?

1076

What happens if you insert a duplicate key for the primary key column in ms sql server?

1029

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1025

Does sql server 2000 clustering support load balancing?

1030

How to read data in a table with "select" statements?

1030

How will you go about resolving deadlocks?

1036

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