Temp Tables

Look, Ma, No Surprises

by Randolph
November 15, 2016November 15, 2016

Last week I demonstrated at least 30% performance improvement by switching to memory optimised table-valued parameters on SQL Server 2016. This week I will demonstrate… Read More »Look, Ma, No Surprises

How to make your T-SQL thirty percent faster

by Randolph
November 8, 2016October 2, 2019

Last week, I mentioned a feature in SQL Server, and now in Azure SQL Database, called Memory-Optimized Table-Valued Parameters, which makes use of In-Memory OLTP… Read More »How to make your T-SQL thirty percent faster

The curious case of RESOURCE_SEMAPHORE

by Randolph
April 25, 2013October 10, 2019

A customer is running in a SQL Server 2000 environment, 32-bit AWE mode, on 64-bit Windows 2003 R2. The server has 16GB of RAM and… Read More »The curious case of RESOURCE_SEMAPHORE