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 5571

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 5439

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

Symphony, TCS, Credit Suisse, GCU,

4 20976

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

4 5058

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

1 6058

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

1 3028

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 104718

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


2 5514

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63349

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

3 5542

Explain Active/Active and Active/Passive cluster configurations

2 13142

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


8 22850

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


7 39919

What is blocking and how would you troubleshoot it?

2 3209

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is Lock table in SQL?


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


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


What is the difference between NOROW and LOCKROW?


How we create SQL Server 2005 Reporting Services ? Give me Sample


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?


which backup strategy you are following at ur company


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


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


How you trouble shoot when any job fails


sql database suspect We have a sql database that is showing as suspect. How can we recover?


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


how to take backup bcp out for a column in table in sql server?


plss anybody specify tha constrian management system in dbms