Answer / venkat

Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.

How to include date and time values in sql statements?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

What is clr ddl trigger?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

---

How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

Explain the disadvantages of cursors?

0 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

What is a covering index?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Explain the truncate command?

0 Answers  

---