how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is an indexing technique?

0 Answers  

---

What is raid? : SQL Server Architecture

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

What are the advantages of using a stored procedure?

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

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

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

---

How can a database be repaired?

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  

---