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

wat is the main diff between sql server 2000and sql server 2005

Jade Software,

6 10049

What is the difference between windows authentication and sql server authentication

HCL,

7 23743

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

IGT,

2171

how can i store resumes in database?

HCL,

3 9842

how many joins we can write if at all we have n no of tables

Tanla Solutions, TS,

5 16104

what is the order of execution of where,having,group by in select stement

IBM, Tanla Solutions,

6 22539

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 7323

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

APX,

6 14638

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 11733

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

Google,

15 16502

i want table name basis on column name.

5 8079

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

iFlex,

3 7727

In clustered and non clustered indexes which one is faster while executing a query ?

1 7770

How to create logins using windows Authentication mode?

2 4733

write the query for taking database restore in sql?

2 5429

Un-Answered Questions { SQL Server }

What is model database? : SQL Server Architecture

1071

What is create command?

935

How to create database with physical files specified in ms sql server?

960

Explain left outer join and right outer join?

984

What is right outer join in sql server joins?

1130

List out different types of normalizations in sql server and explain each of them?

894

What is candidate key with example?

931

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

855

What is truncate table?

902

What do you understand by a view?

944

Does partitioning ssd reduce performance?

857

What is ssrs?

119

Is truncate a dml command?

897

What are the different kinds of ssrs reports?

210

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1014

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