what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

Working with TLogs

0 Answers  

---

What is normalization process?

0 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

---

Can we call stored procedure in view in sql server?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

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,

---

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,

---