The Complete Guide to Temporary Tables and Table Variables - Part 2
In this blog post I am going to focus on a performance comparison between temporary tables and table variables...
top of page
Eitan Blumin
- Dec 14, 2021
- 3 min
Performance Tuning Like a Pro - with Hypothetical Indexes
Leave your peers awe-struck using the "magic trick" of Hypothetical Indexes in SQL Server
evyatar36
- Jul 7, 2021
- 1 min
How Might NUMA Nodes Help You?
One day I received a message from one of my clients who said he is experiencing a HIGH Duration of queries. Together we tried to look for...
Guy Glantser
- Apr 8, 2021
- 5 min
The Complete Guide to Temporary Tables and Table Variables - Part 1
A lot has been said and written about table variables vs. temporary tables in SQL Server. Here is the complete guide...
Guy Glantser
- Dec 2, 2020
- 1 min
Analyzing Execution Plans Like a Pro
Download the session materials from my presentation at the Data Platform Summit 2020.
Eitan Blumin
- Oct 28, 2020
- 2 min
How to Effectively Compress Your Data in SQL Server
Data compression can save storage space and improve performance. But in some cases, it may cause more harm than good. Read to learn more.
bottom of page