Answer / anand k

One table can only one clustered index or primary key and
249 non-clustered index or unique key

Answer / raji

Indexes may be defined as unique or non-unique. A unique
index acts as a constraint on the table by preventing
identical rows in the index and thus, the original columns.

Answer / namz

There can only be one clustered index but multiple non-
clustered index

Answer / koti

250 indexes(1 cluster index,249 non-cluster indexes)

Answer / c.jagadish

In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.

Indexes may be simple index or composite index.

Index formed based on single column values is called simple
index

index formed based on multiple column values is called
composite index.

Default index is NON CLUSTERED INDEX

When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.

Unique--- automatically creates a non clustered index

so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.

Answer / saravanan

four index keys is possible per one table.
read only table u havae create more then index per table

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

what is lazy writer?

1 Answers   Wipro,

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

How many categories of data types used by sql server?

0 Answers  

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

A trigger can reference objects outside the current database? State true or false.

0 Answers  

Differentiate between mongodb vs. Sql server?

0 Answers  

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,