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 you can find out if an index is useful to the optimizer?

0 Answers  

---

Define cross join in sql server joins?

0 Answers  

---

Explain log shipping and mention its advantages.

0 Answers  

---

When would you use the stored procedures or functions?

0 Answers  

---

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

---

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

What is self contained sub query?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

How to create an multi-statement table-valued function?

0 Answers  

---

Explain different forms of normalization?

0 Answers  

---