This chapter focuses on the more advanced elements of data structures and how we interact with them. The topics that will be covered in this chapter should be considered a toolbox that we can call on, should the standard development patterns not be suitable.
Data structures represent physical entities in the SQL Server database, which means they are much harder to change later – especially after they contain data. Due to this, we need to make the right design choices during the design phase. Knowing the benefits and drawbacks of using inheritance and date-time effectiveness is important when designing a technical solution.
In this chapter, we will cover the following recipes:
- Implementing table inheritance
- Using menu items to create a record for a table that uses inheritance
- Using date-time effectiveness
- Creating a view with a query and computed...
