Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.
SQL SERVER – Dynamic SQL and Global Temporary Tables
During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure
SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.
How Many Temporary Tables are Created So Far in SQL Server? – Interview Question of the Week #149
How many temporary tables are created so far in SQL Server? No DMV gives this directly, but here is an easy workaround to find the answer.
SQL SERVER – How to Create A Global Temporary Table?
Readers asked me to cover it after my temp table post. Here is how to create a Global Temporary Table and how it differs from a regular temporary table.
SQL SERVER – How to Create Table Variable and Temporary Table?
New to SQL Server? This simple tutorial shows how to create a Temporary Table and a table variable, how to query them, and how long each one lasts.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
How do you create a Temp Table from a stored procedure when you do not know its result set? Here is the OPENROWSET approach I use, and its drawbacks.