Answer / Piyush Choudhary

In SQL Server, a view is a virtual table that does not store data physically. Instead, it provides an alternative way to query data from one or multiple tables. A view is created by executing a SELECT statement and saving the result set with a specific name.

How can I enforce to use particular index?

1 Answers   Symphony,

---

How do you start single user mode in clustered installations?

1 Answers  

---

Explain what is lock escalation and what is its purpose?

1 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1 Answers  

---

What is an indexing technique?

1 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

1 Answers   EXL,

---

What is full outer join in sql server joins?

1 Answers  

---

What is difference in performance between insert top (n) into table and using top with insert?

1 Answers  

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

In which format does an image save in SQL Server database ?

1 Answers   MCN Solutions,

---

What are the components of dbms?

1 Answers  

---