Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
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 ...
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 ...
Ars Technica

SQL Help: Stored Procedures and the EXEC command

First, a little background. We haven't moved to ASP.NET yet, so I'm still using GetRows() to retrieve recordsets. We have search pages that bring back a certain number of records per page. Right now, ...