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 43625

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

1 4467

Define Check points and End Points?

1 3832

How to know whether our backup is succesfully taken?

1 4140

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

2 5104

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

1 3766

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

Wipro,

2 5735

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

2 5259

What is Schema? and why we use schemas?

4 9077

How do you Implement SSIS Packages in your Project?

1991

Explain Different types of Projects?

1 3937

What is data modeling and Reterminal integrity?

2014

How to restore performance issues and how to check?

2063

Tell about MOM Tool(Microsoft Operator Manager)?

1964

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

1 3992

Un-Answered Questions { SQL Server }

What are the advantages of policy management?

1049

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1194

Explain an incremental backup?

1055

What do you mean by an execution plan?

1193

How can a user-defined datatype be created?

1040

How to use subqueries in the from clause in ms sql server?

1215

Why use update_statistics command in sql server?

1117

What is bookmark link in ssrs?

251

What happens when the SQL Azure database reaches Max Size?

113

What is 2nf example?

1057

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1055

What security features are available for stored procedure?

1080

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2116

How to end a stored procedure properly in ms sql server?

1149

What are the new features in sql server 2016?

1037

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