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

Explain how you can configure a running aggregate in SSRS?

109

---

What are triggers in ms sql server?

599

---

What is Service Broker in sql server 2012?

619

---

What is primary key index?

534

---

Explain the difference between functions and stored procedures in sql server?

476

---

---

How do you implement session management in SQL Server mode?

552

---

What is data modeling and Reterminal integrity?

1490

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

491

---

What is format parameter in ssrs?

109

---

Does full backup break log chain?

543

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

560

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

501

---

How many columns can exist together per table?

703

---

What is the fastest way to permanently delete a 1 million row table named customers?

597

---

Where are SQL server users names and passwords are stored in sql server?

710

---