Does table partitioning improve performance?

0 Answers  

---

What is model database? : SQL Server Architecture

0 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

What is the purpose of self join?

0 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

How many types of triggers are there?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Explain user defined functions?

0 Answers  

---

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

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

Can an entity have two primary keys?

0 Answers  

---