About Torsten Strauß

I am a Microsoft Most Valuable Professional for Data Platform from Germany specialized in Microsoft SQL Server performance tuning, troubleshooting and T-SQL programming. You can meet me at international and national user groups and conferences.

Revival of the Special Interest Group SQL Server Internals

Frank Geisler, Uwe Ricken and Torsten Strauß revive the SIG - SQL Server Internals Group after a long break. As before, we focus on the SQL Server Engine only, which has been expanded with several features in the SQL Server 2019 and thus certainly offers interesting topics. If you are interested in a certain topic, just send us an email or talk to Frank, Uwe or me directly.

By |2020-06-04T15:45:48+02:00June 4th, 2020|Microsoft SQL Server|0 Comments|Reading Time: 2 minutes

Design principles of the in-memory OLTP engine – Avoid CPU and memory overhead for interpreted T-SQL

In this blog, I explain why the in-memory OLTP engine is significantly faster than the traditional on-disk engine. T-SQL is interpreted code with high CPU and memory overhead when SQL Server has to compile the command before it can be executed by the engine. In-memory OLTP reduces the number of recompilations, which may lead to much faster query execution with less impact on CPU and memory.

By |2020-04-17T20:33:58+02:00April 6th, 2020|Microsoft SQL Server|0 Comments|Reading Time: 10 minutes