Yet Another Post About Local Variables In SQL Server

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

Temporal Tables and Table Partitioning In SQL Server: Not If You Like Switching Partitions

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…

Read the post: Temporal Tables and Table Partitioning In SQL Server: Not If You Like Switching Partitions

A Trick For Dealing With Table Variable Modification Performance Problems 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.

Read the post: A Trick For Dealing With Table Variable Modification Performance Problems In SQL Server