Tips for designing SQL Server 2017 tables (Part 2) Use varchar/nvarchar columns instead of text/ntext columns whenever possible. Because SQL Server 2017 stores text/ntext columns on the Text/Image pages separately from the other data, stored on the Data pages, it can take more time to get the text/ntext values. If you need to store integer data from -32,768 through 32,767,...
Tag: referential integrity
SQL Server: Database Design Basics – (Part 2)
SQL Server: Database Design Basics – (Part 2) Author: Basit A. Farooq In this article, you will learn about table design, entities and attributes and their relation to the tables and columns. You will also learn how to enforce data integrity through domain integrity, entity integrity, referential integrity, and user-defined integrity, and how to use primary keys, unique constraints and...