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 ??


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..


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


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.



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


2 4892

what is the difference between table and view

1 1580

plss anybody specify tha constrian management system in dbms

Police Constable,


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?


3 4175

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


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?????


how to overcome kernel isssues


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?


How do you Implement SSIS Packages in your Project?


Working with TLogs


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


What is the difference between NOROW and LOCKROW?


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


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


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


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


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., }


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.


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


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