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 43610

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

1 4463

Define Check points and End Points?

1 3829

How to know whether our backup is succesfully taken?

1 4136

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

2 5102

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

1 3764

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 5256

What is Schema? and why we use schemas?

4 9068

How do you Implement SSIS Packages in your Project?

1989

Explain Different types of Projects?

1 3930

What is data modeling and Reterminal integrity?

2013

How to restore performance issues and how to check?

2060

Tell about MOM Tool(Microsoft Operator Manager)?

1963

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

1 3987

Un-Answered Questions { SQL Server }

Will count(column) include columns with null values in its count?

1149

What is mapping schema?

1072

Please illustrate physical database architecture? : SQL Server Architecture

1032

How do you create type- insensitive operator?

1103

Explain the properties of sub-query in sql server?

1072

How do I partition a table in sql server?

1099

Can the query output be sorted by multiple columns in ms sql server?

1031

What is the sql server 2000 version number?

1150

What to check if a User database is locked?

1117

Is it possible in sql table to have more than one foreign key?

1094

What is sql server management studio? : sql server management studio

1128

How many types of keys are there?

1077

What is mssql?

1034

What do you mean by collation recursive stored procedure?

1111

How much does sql server 2016 cost?

1159

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