Interview Questions – SQL Server
SQL Server – Interview Questions #2
Feb 24th
Database design What is denormalization and when would you go for it? As the name indicates, denormalization is the reverse process of normalization. It’s the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced. How do you implement one-to-one, one-to-many and [...]
SQL Server – Interview Questions #1
Feb 24th
1. What are the different types of Joins? Ans. Joins as used to combine the contents of two or more tables and produce a result set that incorporates rows and columns from each table. Tables are typically joined using data that they have in common Join conditions can be specified in either the FROM or [...]
