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 6848

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

Genpact,

3 8693

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

Scio Healthcare,

3 6329

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

IBM,

2 6206

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 4903

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

AON, Genpact,

8 16700

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 12199

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,

2386

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 8134

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

Accenture,

2 7159

what is the difference between table and view

1 3293

plss anybody specify tha constrian management system in dbms

Police Constable,

2140

How to genrate automaticlly empid like gt001

4 5705

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

Apple,

3 6778

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

IBM, L&T,

3 7064

Un-Answered Questions { SQL Server }

What are “phantom rows”?

1652

what do you understand by change data capture?

998

Does index speed up select statements?

1010

Explain triggers?

999

Explain forward - only cursors?

1050

How to assign null values to variables or columns?

969

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

1084

What is CTE in SQL

940

Explain about protocol layer present in SQL server?

1191

Do you know what is rank function?

1071

How do I perform an unattended install of sql server 2000?

1078

Where is my database stored on the hard disk in ms sql server?

1056

Why truncate is ddl?

1081

What is forward - only cursors / read only cursor?

1082

Why functions are used in sql server?

955

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