What is a sql join?

0 Answers  

---

About Indexed Views? with example? plz reply...

2 Answers  

---

What is row by row processing ?

2 Answers  

---

What is public role in sql server?

0 Answers  

---

What is nonclustered index on computed columns?

0 Answers  

---

---

How to rename databases in ms sql server?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

How to modify an existing user defined function?

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 checkpoint process in the sql server?

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---