Tag: datetimeoffset

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

Tips for using data types in SQL Server 2017

by

Tips for using data types in SQL Server 2017 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 a...

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

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

by

Some tips for designing SQL Server 2016 tables (Part 2) Try to reduce the number of columns in a table. The fewer the number of columns in a table, the less space the table will use, since more rows will fit on a single data page, and less I/O overhead will be required to access the table’s data. Consider using...

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 →