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

Explain what is dbcc?

1003

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

978

Explain what is row_number function?

1016

Tell me what is difference between clustered and non clustered index?

942

Explain the phases a transaction has to undergo?

1054

What is sql service broker?

973

List down some advantages of sql stored procedure?

957

Do you know what are the properties of the relational tables?

1028

Can you explain various data region available in ssrs with their use?

969

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

987

Explain what is log shipping?

1133

What is the significance of null value and why should we avoid permitting null values?

980

Explain what is the use of custom fields in report?

918

Do you know what is bit data type and whats the information that can be stored inside a bit column?

953

Can you explain what are various ways to enhance the ssrs report?

999

Un-Answered Questions { SQL Server }

What is cached report?

143

What is the purpose of grouping data in a report?

962

Explain identity in sql server?

1001

What is model database in sql server?

1047

Ms sql server index?

1060

Tell me what is the significance of null value and why should we avoid permitting null values?

979

Do you know what is a with(nolock)?

1052

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

956

What are the types of stored procedures in an sql server?

984

where the connection string store in the database

2066

What is simple indexing method?

1020

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2018

How to insert stored procedure result into temporary table?

1013

Tell me what is log shipping?

973

How do I find my localdb version?

981

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