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

Do you know what are various aggregate functions that are available?

1215

What are the restrictions while creating batches in sql server?

1113

Tell me what is fill factor?

1011

Explain what is the purpose of sql profiler in sql server?

1128

Explain what is the difference between a local and a global temporary table?

1046

Explain how to integrate the ssrs reports in application?

1063

What are sql dirty pages?

1081

What is transactional replication?

1021

Can you explain full-text query in sql server?

1057

Do you know what is openxml in sql server?

1113

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

1203

Explain go command in sql server?

1090

What is sql stored procedure?

1145

What is blocking?

1132

Do you know query execution plan?

1265

Un-Answered Questions { SQL Server }

Explain an incremental backup?

1049

What is default constraint in ms sql server?

1104

mention different types of relationships in the dbms?

1087

Explain in brief how sql server enhances scalability of the database system?

1026

How to apply filtering criteria at group level with the having clause in ms sql server?

1046

Can group by be used without aggregate functions?

966

How to loop through the result set with @@fetch_status?

1431

what is the difference between delete table and truncate table commands? : Sql server database administration

1079

Explain what is row_number function?

1081

What is the maximum size of a dimension? : sql server analysis services, ssas

1085

What are the triggers in sql?

1168

What is RAID? What are the different types of RAID configurations?

1180

What do you mean by sql server 2005 express management tools?

1353

Why and when do stored procedure recompile?

1029

What are the difficulties faced in cube development? : sql server analysis services, ssas

1099

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