What are the operating modes in which database mirroring runs?

0 Answers  

---

Do comments need to go in a special place in sql server 2005?

0 Answers  

---

Why would you call update statistics?

0 Answers  

---

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

What is named calculation? : sql server analysis services, ssas

0 Answers  

---