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?

1131

What are the restrictions while creating batches in sql server?

1065

Tell me what is fill factor?

965

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

1081

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

1008

Explain how to integrate the ssrs reports in application?

1018

What are sql dirty pages?

1031

What is transactional replication?

973

Can you explain full-text query in sql server?

1016

Do you know what is openxml in sql server?

1074

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

1127

Explain go command in sql server?

1044

What is sql stored procedure?

1100

What is blocking?

1074

Do you know query execution plan?

1184

Un-Answered Questions { SQL Server }

What is meant by datasource?

930

Describe the functionalities that views support.

1108

What is entity data services?

1072

How to create an index on a view?

1072

Determine when to use stored procedure to complete sql server tasks?

1059

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

137

what are the types of indexes? : Sql server database administration

1129

What happens if strings are casted into wrong code pages in ms sql server?

1117

Explain the concepts and capabilities of sql server?

981

What are data driven subscriptions?

115

how many no of arguments can be passed in procedures and functions

5569

What happens to a statement batch if there is a compilation error?

971

What the different components in replication and what is their use?

958

How to maintain a fill factor in existing indexes?

1006

What is difference between rownum and row_number?

975

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