Is dropping temp table in stored procedure code really needed? In this SQL in Sixty Seconds video, I compare two procedures to show what happens.
What is Temp Stored Procedures? – Interview Question of the Week #294
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.
Where are Table Variables Stored? – SQL in Sixty Seconds #095
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
Survey Answers: A Table Design for Questions and Responses
Store survey answers as typed rows instead of one column per question. Then break the design on purpose to see what it blocks and what it cannot.
KEEP PLAN Hint: Cut Temp Table Recompiles in SQL Server
The KEEP PLAN hint gives a temp table the same recompile threshold as a permanent table. This post counts statistics recompiles with Extended Events for a plain query, a KEEP PLAN query and a KEEPFIXED PLAN query. It shows where the hint helps, where it does nothing and what the stronger hint costs.
SELECT INTO Table Variable: Why It Fails and What to Use
SELECT INTO table variable fails with Msg 102 because SELECT INTO creates its target table and a table variable must be declared first. This post shows two working fixes, a declared table variable and a temp table. It also compares them on rollback, dynamic SQL and row estimates.
Detecting Changed Rows With a Row Hash
Compare one fingerprint instead of twenty columns. I show a safe HASHBYTES recipe, the NULL trap that fools CONCAT_WS, and a load that touches only the rows that changed.