Tag: table design

Pro Members SQL Server Standard Members

Tips for designing SQL Server 2017 tables (Part 1)

by

Tips for designing SQL Server 2017 tables (Part 1) Avoid using CLR user-defined data types. SQL Server 2017 supports the CLR user-defined data types. These data types allow implement database data types in any of the languages supported by the .NET Framework CLR. Because using these data types usually provides worse performance than internal SQL Server data types, and you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server: Database Design Basics – (Part 2)

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →