Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

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   HCL,

---

Where do we use trace frag?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

What is a partition function in sql server?

0 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

Can we use having clause without group by?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---