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 43296

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

1 4375

Define Check points and End Points?

1 3738

How to know whether our backup is succesfully taken?

1 4037

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

2 4989

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

1 3692

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

Wipro,

2 5638

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

2 5128

What is Schema? and why we use schemas?

4 8876

How do you Implement SSIS Packages in your Project?

1923

Explain Different types of Projects?

1 3859

What is data modeling and Reterminal integrity?

1952

How to restore performance issues and how to check?

1998

Tell about MOM Tool(Microsoft Operator Manager)?

1907

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

1 3885

Un-Answered Questions { SQL Server }

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

902

What do you understand by user-defined function in the sql server?

948

What is difference between equi join and inner join?

942

Please illustrate physical database architecture? : SQL Server Architecture

982

Explain throw statement in sql server 2008?

985

How to remove duplicate rows from table?

1242

How to perform key word search in tables?

957

What is sqlservr.exe - process - sql server (sqlex?press)?

1104

why would you use sql agent? : Sql server database administration

1206

What is a subquery in a select query statement in ms sql server?

1129

What is a join in sql?

1082

What is the purpose of grouping data in a report?

962

What is the difference between drop table and truncate table?

920

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1021

What happens if null values are involved in boolean operations?

985

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