Answer / Sanjeev Kumar Pandey

Adding a new index to a large table in SQL Server may significantly improve query performance, but it can also slow down insert, update, and delete operations because the database has to maintain the index. However, modern SQL Servers are designed to handle this efficiently.

Which database stores information about replication?

1 Answers  

---

What do you mean by collation recursive stored procedure?

1 Answers  

---

What is a non clustered primary key?

1 Answers  

---

What are the different types of stored procedures?

1 Answers  

---

What are the differences between decimal and float in ms sql server?

1 Answers  

---

Are resultset updatable?

1 Answers  

---

Does view occupy space?

0 Answers  

---

What do you know about normalization and de- normalization?

1 Answers  

---

What are the operating modes in which database mirroring runs?

1 Answers  

---

What are built in functions?

1 Answers  

---

How to generate create view script on an existing view?

1 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---