Answer / Mohammad Arman Ansari

Degenerating or denormalizing a database is done to simplify data access and improve performance in some scenarios. De-normalization eliminates the need for complex joins, reduces the number of tables accessed during queries, and improves read performance at the expense of write performance and data redundancy. However, it increases the complexity of maintaining the database and can lead to data inconsistencies.

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

What Is Rdbms?

1 Answers   Accenture,

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

What is the difference between push and pull subscription? : sql server replication

1 Answers  

---

Explain difference between control flow and data flow?

1 Answers  

---

What is sql server transaction log file?

1 Answers  

---

Write a program to fetch first 10 records from a file?

1 Answers   Amdocs,

---

What is a natural primary key?

1 Answers  

---

What are some examples of schemas?

1 Answers  

---

Explain the difference between functions and stored procedures in sql server?

1 Answers  

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

What are the difference between primary key and unique key? : sql server database administration

1 Answers  

---