Answer / s

A.HASH partitioning is useful on columns which are unique
in nature where range or list partitioning cannot be done.
All the hash partitions hold an equal number of rows
thereby improving the performance and response time of the
query if the table is queried.

List partition is used on a table if you can divide table
based on column value. Something like region wise
partioning if the table contains a column like region.The
advantage of list partitioning is that you can group and
organize unordered and unrelated sets of data in a natural
way.

What port does sql server use?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

What does plv msg allows you to do?

0 Answers  

---

What is varchar sql?

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

What is the difference between sql and isql*plus?

0 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

Does execute immediate commit?

0 Answers  

---