Answer / srinivas

Index is a database object which improves the efficiency of
the query

Answer / guest

When queries are run against a db, an index on that db
basically helps in the way the data is sorted to process the
query for faster and data retrievals are much faster when we
have an index.

Answer / uma

index is used to speed up query execution,indices are used
to locate the tables in the database.

Tell me extended events in sql server 2008?

0 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Explain the disadvantages/limitation of the cursor?

0 Answers  

---

What is indexing in sql server with example?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

Describe in brief authentication modes in sql server.

0 Answers  

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---