What are the advantages of partitioning?

0 Answers  

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

What is ems sql management studio? : sql server management studio

0 Answers  

---

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

Can a table have 2 foreign keys?

0 Answers  

---

Do you know query execution plan?

0 Answers  

---

How to list all objects in a given schema?

0 Answers  

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---