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: timestamp
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 […]