How do you optimize Sql queries ?1227
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 5643
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?4 21566
What's the difference between a primary key and a unique key?4 5220
What are user defined datatypes and when you should go for them?1 6198
What is bit datatype and what's the information that can be stored inside a bit column?1 3124
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement3 5785
Explain Active/Active and Active/Passive cluster configurations2 13328
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?7 40597
What is blocking and how would you troubleshoot it?2 3349
How we create SQL Server 2005 Reporting Services ? Give me Sample
System variable and temporary variables
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Explain Capacity planning to create a database? and how to monitor it?
Why do you want to join software field as you have done your BE in Electronics?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How to trouble shoot if unable to connect SQL Server
tell me the disaster recovery plan
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What is best institute to Learn DotNET And SQL in chennai?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
what is package and it uses and how can u call a package
whats the maximum size of view state??
New concepts of sql server 2005 use in your project.
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do