when would you go for denormalization? : Sql server database administration
- 1 Answers
- 937 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you append an identity column to a temporary table?
What are the properties of the transaction?
What is a coalesce function?
How to provide default values to function parameters?
What are the different SQL Server Versions you have worked on?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are different types of constraints?
How to connect php with different port numbers?
When should you use an instead of trigger?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What kind of problems occurs if we do not implement proper locking strategy?
How do I start sql server 2017?
What is a view in sql?
Can we do dml on views?
Explain system functions or built-in functions? What are different types of system functions?
