Answer / arun pandey

Hi

1)Clustered Index
2)NON-Clustered INdex

But Clustered index is better than non-clusted
becoz the searching in clusterd is faster than non-clustered

Arun Pandey
A1Technology

Answer / s. sundar

1. Clustered Index
2. Non-Clustered Index

Answer / jeff jordan

1) Clustered Index
2) Non-Clustered Index

I'm assuming by "which one is best" we mean which has the
faster look ups. This would be the clustered index since it
is the physical ordering of the rows and the non-clustered
index is like a lookup table. With the clustered index one
you've found the index you've found your row...

Answer / amit choubey

clusterd and non clusterd

Answer / jay vardhan singh

Cluster is faster then non cluster index.We can use only
one cluster index on one table and we can use more then one
non cluster index on one table.

Answer / a.ganesh

not only two type, more type of indexes there
such as Clustered Index with Primary And Index with Uniqu

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

What is difference between rownum and rowid?

0 Answers  

Explain use of expression builder.

0 Answers  

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

What is 1nf normalization form?

0 Answers  

Creating Tables Using SELECT

1 Answers  

What is the log shipping?

0 Answers  

How to connect sql server management studio express to sql server 2005 express?

0 Answers