Tag: smallint

Pro Members SQL Server Standard Members

Tips for using data types in SQL Server 2019 (Part 2)

Tips for using data types in SQL Server 2019 (Part 2) Use Table data type instead of temporary tables whenever possible. A Table data type is a special data type that used for temporary storage of a set of rows. In comparison with the temporary tables, table variables have some benefits. For example, table variables are cleaned up automatically at…...

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.
Log In Register
Pro Members SQL Server Standard Members

Some tips for designing SQL Server 2016 tables (Part 1)

Some tips for designing SQL Server 2016 tables (Part 1) Avoid using timestamp column as a primary key. Timestamp is a data type that exposes automatically generated, unique binary numbers within a database. Every time that a row with a timestamp column is modified or inserted, the incremented database rowversion value is inserted in the timestamp column. This property makes…...

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.
Log In Register