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.

Security Question- SQL DBA exparts, need your help...

3 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

---

What is collation?

0 Answers  

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

Can you explain various data region available in ssrs with their use?

0 Answers  

---

How will you optimize a stored procedure optimization?

0 Answers  

---

Explain ms sql server reporting services vs crystal reports?

0 Answers  

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

How to find the source of a table in sql server?

0 Answers  

---