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

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 10590

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2497

ow to bring suspect mode datbase online from scratch

1802

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2103

wat new abt truncate in sql server

HCL, HP,

2 6823

how to use DTS package in 2000,2005,2008 in sql server

Microsoft,

1831

on line cluster can we make if yes tell me the procedure

Microsoft,

2021

which backup strategy you are following at ur company

2143

your distribution database is full what will u do

2170

Differences between logshipping and mirroring

Microsoft, Syntel,

1 5337

tell me the disaster recovery plan

Microsoft,

2512

application server is slow what may be the problem

Microsoft,

2215

Define the term DML, DDL and DTL?

1 31747

Creating Tables Using SELECT

1 3394

How can I create a table from another table without copying any values from the old table?

3 5720

Un-Answered Questions { SQL Server }

What is the default sql server instance name?

1030

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

1012

How to enable/disable indexes?

1061

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

949

How can we remove orphan records from a table?

980

Explain tablesample?

991

What is merge join?

1192

What is tabulation?

946

How to create user messages with print statements in ms sql server?

983

What is table valued function and scalar valued functions?

1076

What do you understand by sql server agent?

974

How to find tables without indexes?

1086

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

961

Do you know what is rank function?

1071

What is a trigger in sql server?

1165

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