Answer Posted / veerreddy

clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.

other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes

Define cross join in sql server joins?

1019

---

What are logical/boolean operations in ms sql server?

1035

---

How to execute stored procedure and set temp table in sql server?

1034

---

What is sql server schema compare? How we can compare two database schemas?

1027

---

What function does a database engine serve in the sql server?

1032

---

Explain what is analysis service repository?

986

---

What are the properties of the transaction?

1000

---

Can sql servers linked to other servers like oracle?

944

---

Can a database be shrunk with users active?

1125

---

Do you know what guidelines should be followed to help minimize deadlocks?

968

---

How do I find the transaction log size in sql server?

956

---

What are some examples of schemas?

974

---

Can you name a few encryption mechanisms in sql server?

941

---

Explain the difference between function and stored procedure?

938

---

what is spatial nonclustered index

983

---