Answer Posted / 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)

What is difference between line feed ( ) and carriage return ( )?

911

---

What is deploy, process and build? : sql server analysis services, ssas

1114

---

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

1152

---

What is implicit cursors?

1090

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

312

---

How do I setup a local sql server database?

1012

---

How to create an identity column?

1225

---

Can binary strings be converted into numeric or float data types?

1043

---

How do I completely remove sql server instance?

1107

---

What is difference between order by and group by?

1012

---

How to test odbc dsn connection settings?

1038

---

What is the difference between a view and a stored procedure?

1040

---

What are various limitations of the views?

1057

---

Explain what are page splits? : SQL Server Architecture

1072

---

Do you know what are the restrictions that views have to follow?

1081

---