How do you optimize Sql queries ?1180
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 5505
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?4 21154
What's the difference between a primary key and a unique key?4 5127
What are user defined datatypes and when you should go for them?1 6119
What is bit datatype and what's the information that can be stored inside a bit column?1 3060
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement3 5619
Explain Active/Active and Active/Passive cluster configurations2 13213
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?7 40131
What is blocking and how would you troubleshoot it?2 3260
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.
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How do you Implement SSIS Packages in your Project?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
tell me the disaster recovery plan
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is best institute to Learn DotNET And SQL in chennai?
How to trouble shoot if unable to connect SQL Server
How we create SQL Server 2005 Reporting Services ? Give me Sample
how to use DTS package in 2000,2005,2008 in sql server
How to restore performance issues and how to check?
How do use Having,Group by,Group function in SQL?
1 01 101 01010
what is difference between view and Dip.