Explain about Joins?

0 Answers   Infosys,

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

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  

---

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

How to integrate the ssrs reports in application?

0 Answers  

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

How do I port a number to sql server?

0 Answers  

---