SQL Server 2019: Session Context & Parallel Plans
Read OriginalThis technical article examines the use of SESSION_CONTEXT and CONTEXT_INFO functions in SQL Server 2019 for access control and data filtering. It details a discovered limitation where using these functions can prevent queries from utilizing parallel execution plans, impacting performance. The author provides a practical demonstration with setup scripts and query analysis, highlighting a potential pitfall for developers implementing row-level security or similar patterns.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
No top articles yet