Define msdb database?

0 Answers  

---

How many triggers are possible per table?

0 Answers  

---

what is DTS what are tasks available

1 Answers   Wipro,

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

What is the fillfactor concept in indexes?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What are the recovery models for a database?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---