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

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 22711

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 4049

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

Deloitte, Lason,

9 29232

A left outer join B B right outer join A gives the same result then what is the use of two?

1 5437

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8649

event classes in sql server

Accenture, AFE,

2 7916

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11499

what is macro?

Excel, Global Innovation, Wipro,

5 12978

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

2145

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 5722

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 12063

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 9367

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 6312

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 16957

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 10865

Un-Answered Questions { SQL Server }

Why does sql studio use a single registered database repository? : sql server management studio

1041

Why it is recommended to avoid referencing a floating point column in the where clause?

1018

How to create view in stored procedure sql server?

1058

What is role playing dimension with two examples? : sql server analysis services, ssas

1057

What is faster join or union?

1322

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1174

where can you add custom error messages to sql server? : Sql server administration

1178

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1058

What is purpose of normalization?

1001

Do you know what is xpath?

1158

What is SQL Azure Firewall?

136

Explain about link server in sql server?

1120

When would you use it?

1044

Describe the functionalities that views support.

1152

What are key constraints?

1018

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