Answer / Sumit Yadav

A table can have only one clustered index, as the clustered index defines the physical order of data in the table.nCreating an individual index on each column may lead to performance issues due to increased resource consumption, maintenance overhead, and potential locking and blocking. Instead, consider creating composite (multi-column) or filtered indexes for better performance and efficiency.

What are the differences between char and varchar in ms sql server?

1 Answers  

---

What is the latest version of microsoft sql server?

1 Answers  

---

whats the maximum size of view state??

1 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

What do we have to check in database testing?

1 Answers  

---

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

How to create function without parameter in sql server?

1 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

What is the difference between resultset and resultsetmetadata?

1 Answers  

---

What is the difference between Normalization and De-normalization?

1 Answers   TCS,

---