Answer / Ravita

"An MS SQL Server Index is a database object that helps to improve the performance of query operations by allowing faster access to data. It works similarly to an index in a book, where it points to the location of specific information."

What do you understand by a view?

1 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1 Answers  

---

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

---

How to use group functions in the select clause in ms sql server?

1 Answers  

---

What is the contrast amongst drop and truncate?

1 Answers  

---

what is an index? : Sql server database administration

1 Answers  

---

What is global temp table?

1 Answers  

---

What are the commands used in DCL?

1 Answers  

---

What is tempdb in sql server?

1 Answers  

---

Where do we use trace frag?

1 Answers  

---