Tag Archives: Table Design

70 – 451 – Designing Database Tables – Design Tables

Requirements Design tables.  This objective may include but is not limited to: table width, sizing data types, IN_ROW_DATA (BLOBs), overflow data, sparse columns, computed columns, persisted computed columns My Take These requirements seem to be aimed at brining the various … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451 – Designing Database Tables – New Data Types

Requirements Identify the appropriate usage of new data types. This objective may include but is not limited to: geography, geometry, hierarchyid, date, time, datetime2, datetimeoffset, varbinary (max) filestream My Take We will need to know what the new data types … Continue reading

Posted in SQL | Tagged , , | 3 Comments