What are orphan records?

0 Answers  

---

What are “unrepeatable reads”?

0 Answers  

---

What is a deadlock and what is a live lock?

0 Answers  

---

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  

---

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  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What is DCL?

0 Answers  

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---