Answer Posted / chandu

Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.

Non-clustered index:

Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book

What are the dmvs?

1005

---

What is the difference between dbcc indexdefrag and dbcc reindex?

981

---

What are different types of join?

1303

---

Explain hostprotectionattribute in sql server 2005?

1016

---

What is nonclustered index with included columns ?

959

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

944

---

What is the difference between left and right outer join?

1056

---

What new data source types were added in ssrs 2014?

160

---

Explain transaction server consistency?

961

---

Which tcp/ip port does sql server run on? How can it be changed?

1028

---

Can you explain what is the use of custom fields in report?

1052

---

Explain various data region available in ssrs with their use?

925

---

What command is used to delete a table from the database in the sql server and how?

1106

---

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

983

---

Scalability, Availability, Integration with internet, etc.)?

2874

---