Answer Posted / kenatrivedi

Clustered Index is Clustered Index











Non-cluster Index is Non-cluster

how can you attach more than 20 ldf files in sql server

1575

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

582

---

How does Report Builder support Analysis Services cubes?

110

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

575

---

can an order by clause be used in a creation of a view?

697

---

---

What purpose does the model database server?

657

---

What is user-defined multi-statement table-valued function?

659

---

How to provide login information for a new odbc dsn?

540

---

How to use subqueries in the from clause in ms sql server?

571

---

How many categories of data types used by sql server?

600

---

What is logshipping and its purpose?

569

---

Explain collation?

626

---

Explain transaction server implicit?

526

---

Do you know what is a trace frag? Where do we use it?

560

---

Explain the functionalities that views support?

697

---