How do you optimize Sql queries ?1143
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?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
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement3 5542
Explain Active/Active and Active/Passive cluster configurations2 13142
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
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