Answer / naren

Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.

Answer / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Answer / indraneelandhavarapu

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.

What authentication modes does sql server support?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

What is correlated subquery in sql server?

0 Answers  

---

List the various tools available for performance tuning?

0 Answers  

---

Define full outer join?

0 Answers  

---

What are the advantages of paper records?

0 Answers  

---

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

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

Explain what are the restrictions while creating batches in sql server?

0 Answers  

---