Visual Studio Magazine

Speed Up Your Application with Stored Procedure and Temporary Tables

Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...
Ars Technica

MySQL performance tuning (subqueries, temporary tables) | Ars OpenForum

I'm trying to port an application from SQL Server to MySQL (5.6.4) and running into performance issues. MySQL happens to be running on OS X Server, but this seems more like a UNIX question. SELECT ...
Ars Technica

Creating a temporary table in Access 2003 from a recordset in SQL Server 2000

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run ...
Redmond Magazine

What Is TempDB and Why Does It Matter?

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...
GitHub

INSERT and TRUNCATE on temporary table leads to memory leak

TRUNCATE TABLE on a temporary table does not free memory, leading to a memory leak when repeatedly truncating and inserting data into the same temporary table. create table tmp (id uuid); insert into ...