Answer Posted / cla

A query execution plan outlines how the SQL Server query optimizer actually ran or possibly run a query

Can we take the full database backup in log shipping?

719

---

What are different types of raid configurations? : SQL Server Architecture

730

---

What are the purposes and advantages stored procedure?

683

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

709

---

What is left outer join in sql server joins?

696

---

---

What is an identity column in insert statements?

745

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

666

---

How to use subqueries in the from clause in ms sql server?

803

---

what is a mixed extent? : Sql server administration

751

---

What does the on delete cascade option do?

747

---

What is sql sandbox in sql server?

826

---

Can you explain powershell included in sql server 2008?

669

---

Equi join and non equi join is possible with sql server?

663

---

How can we delete a table in sql server?

718

---

What is surrogate key? : sql server analysis services, ssas

867

---