SQL Server Interview Questions
Questions Answers Views Company eMail

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 3560

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

Genpact,

3 4359

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

Scio Healthcare,

3 3256




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

IBM,

2 3863

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 2223

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

Genpact, AON,

8 9633

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,

5 6927

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,

1302




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.

HCL, Cognizant, Value Labs,

1 5617

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

Accenture,

2 4892

what is the difference between table and view

1 1580

plss anybody specify tha constrian management system in dbms

Police Constable,

868

How to genrate automaticlly empid like gt001

4 2637

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

Apple,

3 4175

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

L&T, IBM,

3 3734


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Which is the best place or learning center for MS SQL?????In Bangladesh?????

929


how to overcome kernel isssues

515


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1094


How do you Implement SSIS Packages in your Project?

886


Working with TLogs

732






Does any body please help me what question's have asked for SSRS in the interview?

951


What is the difference between NOROW and LOCKROW?

1361


What are the dis_advantages of stored procedures, triggers, indexes?

1022


If we delete pack Spec what will be the status of pack Body ?

226


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1193


Why do you want to join software field as you have done your BE in Electronics?

1071


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1100


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.

753


what exactly sql injuction.how to overcome.....

1352


If user is owning any SQL Objects, can we drop that user

901