Answer Posted / sureshsamatham

There can be 1 or more indexes in a table.Indexes can be
clustered or non clustered. A clustered index stores data
rows in the table based on their key values. Each table can
have only one clustered index as the key values in the data
rows are unique and the index is built on the unique key
column. Non-Clustered indexes have structures that are
different from the data rows. A non clustered index key
value is used to point to data rows that contain the key
value. This value is known as row locator. The structure of
the row locator is determined on the basis of the type of
storage of the data pages. If the data page is stored as a
heap, a row locator becomes a pointer to a row. If the data
page is stored in a clustered table the row locator is a
clustered index key. Clustered and Non clustered indexes can
be unique and indexes are automatically maintained for a
table or view whenever the data table is modified.

How to add the custom code in Report?

129

---

How to send email from database?

1069

---

What is a covering index?

1040

---

what are the new features in SSRS?

145

---

What are the types of sql server?

1095

---

Mention the differences between having and where clause.

1118

---

How to edit table in sql server 2017?

978

---

What is global temp table?

1045

---

Tell me in brief how sql server enhances scalability of the database system?

1040

---

Explain the concept of view and Types of views in SQL server?

1034

---

Explain what is the purpose of sql profiler in sql server?

1127

---

What is filtered index?

1142

---

What is a result set object returned by mssql_query()?

1226

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1107

---

Can you please explain the difference between function and stored procedure?

1045

---