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.

What is a with(nolock)?

753

---

What the different components in replication and what is their use?

715

---

How to disable triggers using "disable trigger"?

783

---

How to get a list all databases on the sql server?

778

---

What is #table in sql server?

743

---

---

What is the need for indexing?

665

---

What is history table in sql server?

660

---

What is sql server replication? : sql server replication

692

---

Explain how dts is used to extract, transform and consolidate data?

764

---

What are statistics?

780

---

what is sql server? : Sql server database administration

700

---

Explain different types of Normalization.

1213

---

What is standby servers? Explain types of standby servers.

675

---

What do you mean by tablesample?

830

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1916

---