How does a profiler work?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

---

Difference between uniqe index and uniqe constraint?

0 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

What are the components of dbms?

0 Answers  

---

how can we know that how many users are connected in perticuler server??????

2 Answers  

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---