What is difference between count (*) and count 1?

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What are primary keys and foreign keys?

4 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

What is a stored procedure?

3 Answers  

---

what is a cursor and what is its use?

2 Answers   L&T,

---

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  

---

Explain try...catch with sql server?

0 Answers  

---

does physical index sort data

1 Answers  

---

What is the difference between a unique key and primary key?

0 Answers  

---