Answer Posted / samba shiva reddy . m

1.In the select statement give which ever the columns you need
don't give select * from
2.Do not use count()function
3.use indexes and drop indexes regularly it B tree structure we are not going to drop means it will take time for creating indexes it self.
4.when joining the tables use the id's(integer type)not string
5.Sometimes you may have more than one subqueries in your main query. Try to minimize the number of subquery block in your query.
6.Use operator EXISTS, IN and table joins appropriately in your query.
a) Usually IN has the slowest performance.
b) IN is efficient when most of the filter criteria is in the sub-query.
c) EXISTS is efficient when most of the filter criteria is in the main query.
7.Use EXISTS instead of DISTINCT when using joins which involves tables having one-to-many relationship.
8.Try to use UNION ALL in place of UNION.
9.Avoid the 'like' and notlike in where clause.
10.Use non-column expression on one side of the query because it will be processed earlier.
11.To store large binary objects, first place them in the file system and add the file path in the database.

What is pessimistic concurrency?

921

---

What are the difference between primary keys and foreign keys?

914

---

What is key set driven?

893

---

Can truncate be rolled back?

884

---

How to delete duplicate rows?

929

---

How to set database to be single_user in ms sql server?

967

---

What is Replication?

993

---

How would you add a section to a table?

966

---

How to delete multiple rows with one delete statement in ms sql server?

942

---

What is collation sensitivity? Explain different types.

962

---

what is the system function to get the current user's user id? : Sql server database administration

953

---

do you know how to configure db2 side of the application? : Sql server database administration

986

---

What is difference between after and before?

982

---

What is sql server used for?

989

---

Explain different backup plans?

881

---