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

Can Having clause be used without Group by clause?

CarrizalSoft Technologies, CSC, CTS,

6 42995

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 4314

Define Check points and End Points?

1 3675

How to know whether our backup is succesfully taken?

1 3960

What is a Lock and let me know Different types of locks?

2 4888

What is a Trace frag?Where can we use this?

1 3625

How many .ndf files can we create in Sql server 2005?

Wipro,

2 5550

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 5001

What is Schema? and why we use schemas?

4 8712

How do you Implement SSIS Packages in your Project?

1876

Explain Different types of Projects?

1 3782

What is data modeling and Reterminal integrity?

1915

How to restore performance issues and how to check?

1954

Tell about MOM Tool(Microsoft Operator Manager)?

1864

Please tell me some knowledge about Clustering and how to add clustering?

1 3824

Un-Answered Questions { SQL Server }

Define indexes?

1001

What is table level trigger?

962

What is dbcc?

1090

How can sql injection be stopped? : sql server security

968

What are the differences between user defined functions and stored procedures?

1017

What do you mean by an execution plan? Why is it used? How would you view it?

885

What are types of subqueries?

1007

Explain what is it unwise to create wide clustered index keys?

939

What is the need for group functions in sql?

1022

How can I track the changes or identify the latest insert-update-delete from a table?

920

How will you decide the active and passive nodes?

1086

Why people hate cursor?

1103

Mention the different authentication modes in sql server.

971

What are entities and relationships?

929

How do I view views in sql server?

947

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