Tag: GEOGRAPHY

Pro Members SQL Server Standard Members

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...

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
Pro Members SQL Server Standard Members

Tips for using data types in SQL Server 2014

Tips for using data types in SQL Server 2014 Use Date/Time data types to store date/time information separately. In SQL Server 2014 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 modifications...

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
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 data types

Tips for using SQL Server 2012 data types Use tinyint data type, if you need to store integer data from 0 through 255. The columns with tinyint data type use only one byte to store their values, in comparison with two bytes, four bytes and eight bytes used to store smallint, int and bigint values accordingly. For example, if 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