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 anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 6877

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 8702

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 6343

Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 6219

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 4924

Write a query to get all details of employee who has maximum salary from employee table

AON, Genpact,

8 16726

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

Broadridge,

6 12218

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

HCL,

2399

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

Cognizant, HCL, Value Labs,

1 8140

how many non clustered index in sql server 2008,2010,2012

Accenture,

2 7168

what is the difference between table and view

1 3299

plss anybody specify tha constrian management system in dbms

Police Constable,

2150

How to genrate automaticlly empid like gt001

4 5721

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 6793

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

IBM, L&T,

3 7076

Un-Answered Questions { SQL Server }

What is an execution plan?

1149

What is indexed view?

980

Tell me what are cursors and when they are useful?

955

How to write character string constants or literals in ms sql server?

1019

What action plan is preferred if sql server is not responding?

1103

Can an automatic recovery be initiated by a user?

1013

What is the recommended total size of your memory optimized tables?

966

What type of Index will get created after executing the above statement?

1099

What is user defined stored procedures?

944

What is difference between clustered and non clustered index?

989

What are the system database in sql server 2005?

1044

How to replace the Query Result 'Null Value' with a text ?

1042

Is there any difference between the primary key and unique key?

999

How to use old values to define new values in update statements in ms sql server?

1266

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

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