What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

What are the types of constraints?

1 Answers  

---

Explain sql delete command?

0 Answers  

---

What is a trace frag?

0 Answers  

---

Explain the difference between clustered and non-clustered index?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

What is an extended Stored Procedure?

1 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  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

---