When a variable is declared in a T-SQL stored procedure, is it kept in memory or tempdb?
The Capacity Planning article for tempdb answers your questions:
The large object data types are varchar(max), nvarchar(max), varbinary(max) text, ntext, image, and xml. These types can be up to 2 GB in size and can be used as variables or parameters in stored procedures, user-defined functions, batches, or queries. Parameters and variables that are defined as a LOB data type use main memory as storage if the values are small. However, large values are stored in tempdb. When LOB variables and parameters are stored in tempdb, they are treated as internal objects. You can query the sys.dm_db_session_space_usage dynamic management view to report the pages allocated to internal objects for a given session.
The article is worth reading in its entirety, because it also covers a lot of the other uses for tempdb.
EDIT: If you're curious how much memory in tempdb a specific session is using, you can run the following query:
select *
from sys.dm_db_session_space_usage
where session_id = @@SPID
Using this, it didn't look like my VARCHAR(MAX)
variable was stored in tempdb until it reached around 1000 KB in size... but I'm sure that varies based on the memory that your server has available.