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 10246

What is the difference between windows authentication and sql server authentication

HCL,

7 24087

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,

2212

how can i store resumes in database?

HCL,

3 9981

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

Tanla Solutions, TS,

5 16306

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

IBM, Tanla Solutions,

6 22800

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 7396

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

APX,

6 14821

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 12039

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 16980

i want table name basis on column name.

5 8263

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 7866

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

1 7870

How to create logins using windows Authentication mode?

2 4841

write the query for taking database restore in sql?

2 5550

Un-Answered Questions { SQL Server }

How to connect sql server management studio express to sql server 2005 express?

1042

What is the downside of using udf?

1109

Explain an incremental backup?

1001

Can you explain what are various ways to enhance the ssrs report?

1002

How to locate and take substrings with charindex() and substring() functions?

1016

Explain syntax for disabling triggers?

1040

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1051

How to modify an existing user defined function?

1103

List down some advantages of sql stored procedure?

963

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

4384

If a table does not have a unique index, can a cursor be opened on it?

915

What is isolation levels?

1029

What's new in sql management studio for sql server? : sql server management studio

1065

What is the use of “join” in sql server?

1090

Do you think BCNF is better than 2NF & 3NF? Why?

1278

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