State a few properties of relational databases?

0 Answers  

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What is a mixed extent?

0 Answers  

---

---

How to create a trigger for insert only?

0 Answers  

---

What is self join in sql server joins?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

Why union all is faster than union?

0 Answers  

---

What is table valued function and scalar valued functions?

0 Answers  

---

Is it possible in sql table to have more than one foreign key?

0 Answers  

---

What is spatial and temporal data?

0 Answers  

---