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 fan-out query in SQL Azure?

123

List types of tables in SQL Azure?

128

Explain tables in SQL Azure?

122

What is the index requirement in SQL Azure?

How to scale out a federation by Sql statement?

118

What is SQL Azure Federations?

114

How to Sync Two SQL Azure Databases?

121

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

Explain differences between web edition and business edition?

119

What is the difference between web edition and business edition?

113

What are the differences between web role and worker role?

124

What is TDS(Tabular Data Stream) Gateway?

127

How to connect Azure federated root database and apply federation in entity framework?

109

What is Federation and Federation Member?

Un-Answered Questions { SQL Server }

Explain query editor regions

1115

Can you insert NULL in unique column?

1213

Does order by actually change the order of the data in the tables or does it just change the output?

1209

Explain atomicity?

1133

What is the difference between system objects and user objects?

1220

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

991

What are data resources?

965

Explain SSRS Architecture?

203

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1114

how would you improve etl (extract, transform, load) throughput?

1078

How to get a list of columns in a view using the "sp_help" stored procedure?

1099

What are the general features of sql server management studio? : sql server management studio

1136

How to connect ms access to sql servers through odbc?

1074

How to use clusters?

1021

What are the drawbacks of reporting in ssrs?

159

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