Answer / ramesh.p

The difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.

Answer / vijaya

In Clustered Index, the data is physically sorted.
only one Clustered Index is created per table.
The data is stored in heap level of the B-tree.

In non-clustered Index, the physical order of the rows is
not same as the order of index.
there can be upto 249 non-clustered index per table.
the data is present in the random order but the logical
ordering is specified by the index.

Answer / hari

while creating primary key it will create cluster index.
while creating unique key it will create noncluster index
---cluster index it will create only one per table
---Non Cluster index it will create up to 249 per table
--cluster index physical sort the data
--Non cluster index logical sort the data.

Answer / vikas kant

Clustered index is a special type of index that reorders
the way in which the data is pysically stored in table.A
table can have just 1 clustered index.leaf nodes of a
clustered index contains the datapages.

Non clusterd index is also a special type of index in which
the logical order of the index doesnt match physical stored
rows on the disk.A table can have multiple indexes probably
(16).

Answer / anjan ghosh

when we create index then we assign a primary or unique
field , after insert of records , the results is
clustered--(field) order by
nonclustered--no order(logical order)

create table nonclusterindex(Emid int,data varchar(800))
create table clusterindex(Emid int,data varchar(800))

create unique nonclustered index nonclusterindex_emid on
nonclusterindex (Emid)

create unique clustered index clusterindex_emid on
clusterindex (Emid)

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

What are user-defined functions (udfs) in sql server?

0 Answers  

How to execute a sql statement using mssql_query()?

0 Answers  

What is normalization according to you and explain its different levels?

0 Answers  

Can we create clustered index on composite key?

0 Answers  

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

What is the tcp/ip port on which sql server runs?

0 Answers  

How to create a simple table to test triggers in ms sql server?

0 Answers  

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

Explain what is lock escalation and what is its purpose?

0 Answers  

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

check, not null,unique

2 Answers   IBM,