Press "Enter" to skip to content

Reducing Memory Grants with Views

Erik Darling shows a rare case in which a view can improve performance:

They may have read, of course, that SQL Server’s super-smart variable length data types only consume necessary space.

It’s free real estate.

Except it isn’t, especially not when it comes to query memory grants.

I’m so used to views messing up performance rather than improving them.