How can you control the amount of free space in your index pages?

0 Answers  

---

What is sleeping status in sql server?

0 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---

Can truncate be rolled back?

0 Answers  

---

Can we insert data into a view?

0 Answers  

---

---

How global temporary tables are represented and its scope?

0 Answers  

---

Define right outer join?

0 Answers  

---

Explain view in sql server?

0 Answers  

---

How to execute a stored procedure in ms sql server?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

What is the purpose of using COLLATE in a query?

1 Answers  

---