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 is the temp table?

874

---

what is a correlated sub-query? : Sql server database administration

904

---

How to disable triggers using "disable trigger"?

1012

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1024

---

What is index in an assignment?

899

---

How to enable/disable indexes?

1020

---

What are a scheduled jobs or what is a scheduled tasks?

863

---

Is it important for a database administrator to understand the operating system and file access?

937

---

What is the difference between a stored procedure and a user defined function?

980

---

What are the triggers in sql?

1034

---

What are the new features of sql server 2012 reporting service?

125

---

Why do we partition data?

981

---

Explain the microsoft sql server delete command?

966

---

Can an automatic recovery be initiated by a user?

948

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---