Answer / laxman

stored as mdf & ldf files

What is the difference between referencing and joining?

1 Answers  

---

How do I trace a query in sql server?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

How to check status of stored procedure in sql server?

0 Answers  

---

What are page splits?

0 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

What is a print index?

0 Answers  

---

what is diffrent between store procedure and trigger

2 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---