What is De-normalization?
Submitted by: AdministratorThe process of adding redundant data to get rid of complex join, in order to optimize database performance. This is done to speed up database access by moving from higher to lower form of normalization.
Submitted by: Administrator
Submitted by: Administrator
Read Online SQL Server Functions Job Interview Questions And Answers
Top SQL Server Functions Questions
| ☺ | Explain Steps of normalization? |
| ☺ | What is De-normalization? |
| ☺ | Explain how DTS is used to extract, transform and consolidate data? |
| ☺ | Do you know exporting and importing utility? |
| ☺ | What are scalar functions? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
