May 2023
Intermediate to advanced
992 pages
31h 14m
English
book
SQL Server 2022 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Deepthi Goguri, Elizabeth Noble, Meagan Longoria, Joseph D'Antoni, Louis Davidson
Content preview from SQL Server 2022 Administration Inside Out
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 7
Understand table features
A key aspect of relational databases is how data is stored in tables. It is important to understand both how tables should look to the user and how they are structured internally.
This chapter covers fundamentals including data types, keys, and constraints. It also covers special table types, including temporal tables and graph tables. At times, organizations choose to store binary large objects (BLOBs) within relational tables. This chapter covers the implications of storing this type of data within SQL Server, as well as ...