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 the current limitation of the size of SQL Azure DB?

124

What happens when the SQL Azure database reaches Max Size?

111

How do you improve the performance of a SQL Azure Database?

137

What were the latest updates to SQL Azure service?

111

When does a workload on SQL Azure get throttled?

131

What Are the Main Features of SQL Azure?

117

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What is SQL Azure Fabric?

110

How to connect to SQL Azure Database by using sqlcmd?

136

What is SQL Azure Data sync?

121

Which are the two editions in which SQL Azure database available?

119

Explain in details security in SQL azure?

121

Ways to improve the performance of a SQL Azure Database?

125

Un-Answered Questions { SQL Server }

What is the difference between seek predicate and predicate?

1053

What is database black box testing?

1029

Do you know nested transaction?

955

Explain database normalization?

1214

How to execute a sql statement using odbc_exec()?

1136

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

938

What authentication modes does sql server support?

1093

What is the stuff?

993

What does executeupdate return?

971

how you can move data or databases between servers and databases in sql server? : Sql server administration

959

What is collation?

1136

what are the important architecture components of SSRS?

140

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1007

How to add code to the existing article (using improve article)?

1104

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

1095

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