How do you optimize Sql queries ?1191
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 5543
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?4 21276
What's the difference between a primary key and a unique key?4 5153
What are user defined datatypes and when you should go for them?1 6143
What is bit datatype and what's the information that can be stored inside a bit column?1 3076
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement3 5672
Explain Active/Active and Active/Passive cluster configurations2 13244
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?7 40272
What is blocking and how would you troubleshoot it?2 3286
how can you attach more than 20 ldf files in sql server
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
System variable and temporary variables
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
what is the sql equivaent of the dataset relation object ?
How much memory that we are using in Logshipping Concept?
What is the difference between NOROW and LOCKROW?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
where the connection string store in the database
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
1 01 101 01010
Comment,Datatypes are unlimited