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...
Tag: uniqueidentifier
Some tips for using data types in SQL Server 2016
Some tips for using data types in SQL Server 2016 Use Date/Time data types to store date/time information separately. In SQL Server 2016 you can store the date and time information separately. For example, if you need to work with date data only, use the Date data type instead of datetime or smalldatetime to optimize storage space and simplify date […]