Answer / Vineet Kumar

A data file is a computer file that stores data, such as text, numbers, or images. Data files can be created and managed by various applications and are used to store, retrieve, and manipulate information.

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.

1 Answers   IBM,

---

Is natural join and equi join same?

1 Answers  

---

What is the purpose of object explorer and its features? : sql server management studio

1 Answers  

---

Can another user execute your local temporary stored procedures?

1 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

How can we rewrite sub-queries into simple select statements or with joins?

1 Answers  

---

What is instead of trigger sql server?

1 Answers  

---

List the types of recovery model available in sql server?

1 Answers  

---

What are the differences between char and nchar in ms sql server?

1 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

How do I find the sql server version?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---