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 the use of floor function in sql server?

1132

---

Can you explain different types of locks in sql server?

995

---

What is resource governor?

1034

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

---

What is enhanced database mirroring in sql server 2008?

1037

---

What are the steps to insert a table?

995

---

How do we know if any query is retrieving a large amount of data or very little data?

1034

---

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

158

---

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

1125

---

What stored by the model?

1141

---

Explain use of expression builder.

1071

---

Delete duplicate rows without using rowid.

1588

---

Explain about the command-line tool SQLCMD?

1147

---

Can sql server be linked with other servers like oracle?

1024

---

What is relationship? What number of sorts of relationship are there?

1224

---