Answer Posted / samrat sen

Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.

whats new about truncate in sql server 2008?

2493

---

What are the purpose of Normalisation?

1046

---

What is difference between table aliases and column aliases? Do they affect performance?

958

---

What are the advantages of partitioning?

1097

---

Why use stored procedures in sql server?

1000

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

937

---

What is database isolation in sql server? : sql server database administration

1093

---

What is sql server management studio? : sql server management studio

1064

---

Can you explain what is sql server english query?

992

---

Explain nested trigger in sql?

1061

---

What were the latest updates to SQL Azure service?

111

---

What is the standby server?

946

---

Can you edit the .rdl code associated with a linked report?

162

---

How to get all stored procedures in sql server?

990

---

what method you can use to reduce the overhead of Reporting Services data sources?

253

---