Answer / somu

We can create total 250 indexes per table . i,e 1 Clustered
Index and 249 Non Clustered Indexes

Answer / sanjay kumar dinda

Two types of indexes are there in SQL Server
1. Clustered Index
2. Non-Clustered Index

We can create only 1 Clustered index in a table as it re-
orders the data of the table
We can create upto 249 Non-Clustered index in a table...

Answer / infant vinoth

surely we can create an index,
one cluster index,249 will be the non cluster..all the best

Answer / 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.

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

What is database architecture? : SQL Server Architecture

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

What are the types of indexes?

0 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

How do clustered indexes store data?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---