SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?



Rate yourself in .NET and SQL ?

SunGard, HCL, Cognizant,

1 5514

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 5384

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Symphony, TCS, Credit Suisse, GCU,

4 20758

What's the difference between a primary key and a unique key?

4 4992

What are user defined datatypes and when you should go for them?

1 6014

What is bit datatype and what's the information that can be stored inside a bit column?

1 2989

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 104528

What are defaults? Is there a column to which a default can't be bound?


2 5447

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63082

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 5481

Explain Active/Active and Active/Passive cluster configurations

2 13070

What is RAID and what are different types of RAID configurations?


8 22687

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?


7 39721

What is blocking and how would you troubleshoot it?

2 3171

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


what is package and it uses and how can u call a package


Why we need to use secondry database file? though, we can do same work using primary database file also.


What is Lock table in SQL?


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)


What is the difference between online clustering and Offline clustering?


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




How retrieve field names from the table in SQL through JAVA code?


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


How do use Having,Group by,Group function in SQL?


System variable and temporary variables


can any body tell me how to know the password of current user in sql server


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?