What are the different types of subquery?

0 Answers  

---

What are the tables in sql?

0 Answers  

---

What are different types of constraints?

0 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

---

What is buffer cash and log cache in sql server?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

What function does a database engine serve in the sql server?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---