How you can minimize the deadlock situation?

0 Answers  

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

---

Can you pass expressions to function parameters?

0 Answers  

---

How you can change a cross join into an inner join?

0 Answers  

---

What is the library index called?

0 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---