What is partitioned view?

0 Answers  

---

Write query to return all rows sql?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

---

What is de-normalization and what are some of the examples of it?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

What is ddl and dml commands?

0 Answers  

---

Write the syntax for stuff function in an sql server?

0 Answers  

---

What is read uncmmited?

0 Answers  

---