Table variables in SQL Server 2019 get a table cardinality estimate through deferred compilation, but they still have no column-level statistics, so plans…
Read the post: How Are Table Variables Different In SQL Server 2019?
AI Training for Database Teams and SQL Server Performance Tuning
Table variables in SQL Server 2019 get a table cardinality estimate through deferred compilation, but they still have no column-level statistics, so plans…
Read the post: How Are Table Variables Different In SQL Server 2019?
Normally, I link people to this post by Kendra and this post by Paul when I need to point them to information about what goes wrong with local variables.
Read the post: Yet Another Post About Local Variables In SQL Server
Signs Your SQL Server Execution Plan Is Lying To You: Cached Temp Tables: a SQL Server video lesson from Erik Darling of Darling Data.
Read the post: Signs Your SQL Server Execution Plan Is Lying To You: Cached Temp Tables
You already know that your temp table needs an index. Let’s say there’s some query plan ouchie from not adding one.
Read the post: When Should You Index Temp Tables In SQL Server?
This is the part of SQL Server I often find myself rolling my eyes at: poor feature interoperability, and that V1 smell that… never seems to turn into that…
Signs Your SQL Server Execution Plan Is Lying To You: Table Variable Cardinality Estimation: a SQL Server video lesson from Erik Darling of Darling Data.
How Table Variables Prevent SQL Server From Using A Parallel Query Plan: a SQL Server video lesson from Erik Darling of Darling Data.
Read the post: How Table Variables Prevent SQL Server From Using A Parallel Query Plan
Intermediate result materialization is one of the most successful tuning methods that I regularly use.
Read the post: What Kind Of Indexes Can You Create On SQL Server Temporary Objects?
In yesterday’s post, we looked at we looked at simple scalar function plan caching.
Read the post: Function Plan Caching In SQL Server: Multi Statement Table Valued Functions
Let’s say you have dynamic SQL that selects different different data based on some conditions.
Read the post: Creating #Temp Tables Dynamically In SQL Server
One of the many current downsides of @table variables is that modifying them inhibits parallelism, which is a problem #temp tables don’t have.
Indexes are good for so much more than what they’re given credit for by the general public.
Read the post: Are Table Variable Indexes Ever Useful In SQL Server?
Sometimes there’s a need to copy tables from one database to another. A large INSERT to copy all of the rows at once may not be desired or possible.
Read the post: Copying Large Tables Efficiently In SQL Server
Copyright © 2019-2026 Darling Data