Answer / Prateek Srivastava

Denormalization is used to improve the performance of a database by reducing the number of joins required to retrieve data. You may choose to denormalize a database in the following scenarios:
1. Frequent complex queries involving multiple tables.
2. Low update frequency for tables with high read activity.
3. To reduce the overall complexity of the database design.

Mention the differences between substr and charindex in sql server.

1 Answers  

---

What is normalization?

9 Answers  

---

If a stored procedure is taking a table data type, how it looks?

2 Answers  

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

What is difference statement and preparedstatement?

1 Answers  

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1 Answers  

---

What is the difference between insensitive and scroll cursor?

1 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

What is msdb database? : SQL Server Architecture

1 Answers  

---

What is the difference between nvl and nvl2?

1 Answers  

---

What are the mathematical functions supported by sql server 2005?

1 Answers  

---

Explain some stored procedure creating best practices or guidelines?

1 Answers  

---