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