Answer / Vipin Kumar Vaishya

The maximum size of a column in SQL Server depends on the data type. For example, varchar(max) can store up to 2^63 - 1 characters (approximately 17 billion characters), while nvarchar(max) can store approximately 900 billion characters due to Unicode encoding.

Write a program using SQL queries to find a unique entry in a table.

1 Answers   Tech Mahindra,

---

Difference between DELETE and TRUNCATE?

1 Answers   Atos, TCS,

---

What is the difference between clustered and a non-clustered index?

1 Answers   NA,

---

Why can there be only one clustered index and not more than one?

1 Answers  

---

What is MSDE?

2 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1 Answers  

---

Explain the collation?

1 Answers  

---

What is the difference between Normalization and De-normalization?

1 Answers   TCS,

---

Can primary key be a foreign key?

1 Answers  

---

Which database stores information about replication?

1 Answers  

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1 Answers   ABC,

---

What are the restrictions that views have to follow?

1 Answers  

---