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

Can we drop user if user mapped to any logins

1 3285

How to transfer Logins from SQL Server 2000 to 2005

2 3932

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1888

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 3241

what is the Ticketing tool used in Wipro technologies at Bangalore...???

Liquid Hub,

8156

find the 3rd max salary

10 11153

How to Handle the exceptions in Sqlsrver 2005??

Value Labs, Wipro,

3 7368

What is best institute to Learn DotNET And SQL in chennai?

2161

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

TCS,

2 4780

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1903

how do u find least salary in a table

4 6453

Delete duplicate records from the table?(Table must have unique id)

TCS, Thomson Reuters,

7 12353

Why we are using the sql language?. What is the purpose of using this?

2 4093

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 4619

How do you connect 100 files as a flat file sources in one package of SSIS?

2 5196

Un-Answered Questions { SQL Server }

Sql server reporting services vs. Crystal reports.

131

What is usually the first word in a sql query?

1135

can you implement data mining in SSRS?

148

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

What are the requirements for sql server 2016?

882

What are database states in ms sql server?

1180

What are data resources?

911

What is difference between count (*) and count column?

903

What do you understand by user-defined function in the sql server?

951

What is an inner join?

983

What is lock escalation and what is its purpose?

974

What is the order in which the sql query is executed?

942

What is entity data services?

1064

What is store procedure? When do you use?

936

Is it important for a database administrator to understand the operating system and file access?

993

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