Tag: Java data types

Pro Members SQL Server Standard Members

Tips for using data types in SQL Server 2019 (Part 1)

by

Tips for using data types in SQL Server 2019 (Part 1) Consider using Java data types. In SQL Server 2019 Java data types are currently supported for Input/Output data sets and Input/Output parameters. For example, you can execute a Java script by using the sp_execute_external_script system stored procedure. Use bigint data type, if you need to store integer data from...

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

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 →