Tag: in-memory oltp

Pro Members SQL Server Standard Members

Useful SQL Server 2019 features

by

Useful SQL Server 2019 features 1. Memory-optimized TempDB metadata. In SQL Server 2019 Microsoft introduces a new feature that is part of the In-Memory Database feature family. This is memory-optimized TempDB metadata. Now the system tables involved in managing temporary table metadata can be moved into latch-free non-durable memory-optimized tables. Use the following script to turn on the memory-optimized TempDB...

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

Troubleshooting SQL Server 2017 In-Memory OLTP

by

Troubleshooting SQL Server 2017 In-Memory OLTP If you have problems with In-Memory OLTP in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. You may notice a temporary decrease in performance for In-Memory OLTP transactions when using In-Memory OLTP with Always On availability groups. This problem occurs when the availability group is configured to use the synchronous-commit...

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

Tips for using temporary tables in SQL Server 2017

by

Tips for using temporary tables in SQL Server 2017 Consider creating indexes on the very large temporary tables. The temporary tables provides much more efficient way to access their data in comparison with general tables, but if you work with very large temporary tables, using indexes can greatly improve performance. Use Table data type instead of temporary tables whenever possible....

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

Tips for using views in SQL Server 2017

by

Tips for using views in SQL Server 2017 Consider using stored procedures instead of using views. The stored procedures much more flexible than views. For example, a stored procedure can contain insert, delete, update statements, can call other stored procedures, or extended stored procedures, and so on. Use views instead of heavy-duty queries to reduce network traffic. Using views instead...

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

Tips for using Very Large Databases in SQL Server 2017

by

Tips for using Very Large Databases in SQL Server 2017 Create a user-defined filegroup and create some tables in it to run maintenance tasks (backups, DBCC, update statistics, and so on) against these tables. You can place a table in its own filegroup and can backup and restore only this table. So you can group user objects with similar maintenance...

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

Troubleshooting SQL Server 2016 In-Memory OLTP

by

Troubleshooting SQL Server 2016 In-Memory OLTP If you have problems with In-Memory OLTP in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 In-Memory OLTP bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...

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

Tips for using Very Large Databases in SQL Server 2016

by

Tips for using Very Large Databases in SQL Server 2016 Try to create as many database files, as there are physical disk arrays so that you have one file per disk array. This will improve performance, because when a table is accessed sequentially, a separate thread is created for each file on each disk array in order to read the...

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

Some tips for using temporary tables in SQL Server 2016

by

Some tips for using temporary tables in SQL Server 2016 Consider using system-versioned temporal tables. A system-versioned temporal table is a new type of user table in SQL Server 2016 that provides correct information about stored facts at any point in time. Each temporal table consists of two tables actually, one for the current data and one for the historical...

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

Some tips for using views in SQL Server 2016

by

Some tips for using views in SQL Server 2016 Use views to enhance security and conceal underlying data objects. For example, you can give to users the permission to access a view, which contain a restricted set of the columns and data, not allow selecting or updating the underlying data objects. By using views, the permission management could also be...

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

Tips for using temporary tables in SQL Server 2014

by

Tips for using temporary tables in SQL Server 2014 Consider using memory-optimized table variables instead of a traditional table variable to reduce tempdb use. SQL Server 2014 introduced In-Memory OLTP (In-Memory Optimization). In-Memory OLTP introduces the memory-optimized tables and the memory-optimized table type. A table variable created using a memory-optimized table type is a memory-optimized table variable. Memory-optimized table variables...

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
Continue Reading →