Tips for using data types in SQL Server 2019 (Part 2) Use Table data type instead of temporary tables whenever possible. A Table data type is a special data type that used for temporary storage of a set of rows. In comparison with the temporary tables, table variables have some benefits. For example, table variables are cleaned up automatically at...
Tag: sql_variant
Some tips for designing SQL Server 2016 tables (Part 2)
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...
Some tips for designing SQL Server 2016 tables (Part 1)
Some tips for designing SQL Server 2016 tables (Part 1) 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...
Some tips for designing SQL Server 2014 tables
Some tips for designing SQL Server 2014 tables Create the table’s columns as narrow as possible. This can reduce the table’s size and improve performance of your queries as well as some maintenance tasks (such as backup, restore and so on). Try to reduce the number of columns in a table. The fewer the number of columns in a table,...
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...
Tips for designing SQL Server 2012 tables
Tips for designing SQL Server 2012 tables 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. Use char/varchar columns instead of...