articles

Articles of SQLschool.gr Team

Session Context in SQL Server

Antonios Chatzipavlis

Sunday 23 September 2018

Presentation Code

declare @i int  = 10

select @i+10
go

select @i+20
go


/***********************************************************************/


exec sp_set_session_context @key=N'i', @value=N'10'
go

select SESSION_CONTEXT(N'i')+10

go

select SESSION_CONTEXT(N'i')+20
go


/***********************************************************************/

exec sp_set_session_context @key=N'i', @value=N'10'
go

select cast (SESSION_CONTEXT(N'i') as int )+10

go

select cast (SESSION_CONTEXT(N'i') as int )+20
go

/***********************************************************************/

exec sp_set_session_context @key=N'i', @value=N'10', @read_only=1
go

select cast (SESSION_CONTEXT(N'i') as int )+10

go

select cast (SESSION_CONTEXT(N'i') as int )+20
go

exec sp_set_session_context @key=N'i', @value=N'11', @read_only=1
go

/***********************************************************************/
-- The total size of the session context is limited to 256 kb.

SELECT * FROM sys.dm_os_memory_cache_counters WHERE type = 'CACHESTORE_SESSION_CONTEXT';
go

Antonios Chatzipavlis

Antonios Chatzipavlis is a highly experienced Data Solutions Consultant and Trainer. He has been working in the IT industry since 1988, holding various roles such as senior developer, IT Manager, Data & AI Solutions Architect and Consultant.

Since 1995, Antonios has focused on modern technologies and software development tools, primarily by Microsoft. He has specialized in Data & AI since 2000, with expertise in Microsoft Data Platform (SQL Server, Azure SQL Databases, Azure Synapse Analytics, Microsoft Fabric, Power BI, AI) and Databricks.

Antonios is also a Microsoft Certified Trainer (MCT) for over 25 years, has been recognized as a Microsoft Most Valuable Professional (MVP) in Data Platform since 2010 and he is in the Data Expert 40 Powerlist 2024 by Boussias. He is the co-founder and visionary behind XLYTiCA, a company dedicated to Data & AI solutions.