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 10604

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2502

ow to bring suspect mode datbase online from scratch

1806

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?

2105

wat new abt truncate in sql server

HCL, HP,

2 6832

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

Microsoft,

1838

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

Microsoft,

2023

which backup strategy you are following at ur company

2147

your distribution database is full what will u do

2172

Differences between logshipping and mirroring

Microsoft, Syntel,

1 5347

tell me the disaster recovery plan

Microsoft,

2516

application server is slow what may be the problem

Microsoft,

2222

Define the term DML, DDL and DTL?

1 31758

Creating Tables Using SELECT

1 3394

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

3 5725

Un-Answered Questions { SQL Server }

what is difference between NULL and ISNULL in SQL Server 2008?

1014

Can an automatic recovery be initiated by a user?

1013

Explain go command in sql server?

1033

What is raid, and how it can influence database performance?

1054

What are date and time data types in ms sql server?

1092

How to get a list of columns in a view using the "sp_columns" stored procedure?

1040

What are the requirements for sql server 2016?

882

What are subqueries in sql server?

1120

Can one drop a column from a table?

1020

Name few endpoints exposed by ssrs 2012?

355

Explain about Views?

1067

Explain transaction server consistency?

973

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

1019

Explain few of the new features of sql server 2008 management studio

918

Where are sql server user names and passwords stored in sql server?

1090

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