Answer / raj

The index is Nothing but quickly show the data on screen.
it's used for fast retrivel of data from tables.

Why do you need a sql server?

0 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---

Can we add an identity column to decimal datatype?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What do you mean by data integrity?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---