What are the different types of replication you can set up in sql server?

0 Answers  

---

What is the maximum number of index per table?

0 Answers  

---

How to test subquery results with the exists operator?

0 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

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,

---

How to rebuild master databse?

0 Answers  

---

What is the default value of an integer data type in sql server 2005?

0 Answers  

---

What are transactions and its controls?

0 Answers  

---

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,

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

Does an index slow down updates on indexed columns?

0 Answers  

---

What is table join?

0 Answers  

---