Tag: table variables

Pro Members SQL Server Standard Members

Tips for using temporary tables in SQL Server 2019

by

Tips for using temporary tables in SQL Server 2019 Try to avoid using temporary tables inside your stored procedure. Using temporary tables inside stored procedure reduces the chance to reuse the execution plan. 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...

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

Back to basics: Transact-SQL programming fundamentals – (Part 1)

by

Back to basics: Transact-SQL programming fundamentals – (Part 1) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learn how to use scripts and batches, and basics of Transact-SQL variables. SQL Server users use Transact-SQL programming to create sets of statements for ad hoc execution. The aim of the Transact-SQL programming is to carry...

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 →