KB441623: Slow performance while querying tables that have columns set to varchar(max) or char(max) data types.
![What is the Size of the LOB Pointer for (MAX) Types Like Varchar, Varbinary, Etc? | Mark S. Rasmussen What is the Size of the LOB Pointer for (MAX) Types Like Varchar, Varbinary, Etc? | Mark S. Rasmussen](https://improve.dk/what-is-the-size-of-the-lob-pointer-for-max-types-like-varchar-varbinary-etc/image_4.png)
What is the Size of the LOB Pointer for (MAX) Types Like Varchar, Varbinary, Etc? | Mark S. Rasmussen
![SQL: What's the right column length for storing email addresses in a SQL Server database? - The Bit Bucket SQL: What's the right column length for storing email addresses in a SQL Server database? - The Bit Bucket](https://blog.greglow.com/wp-content/uploads/2019/06/EmailAddress_FeaturedImage.png)
SQL: What's the right column length for storing email addresses in a SQL Server database? - The Bit Bucket
![SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length - SQL Authority with Pinal Dave SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length - SQL Authority with Pinal Dave](https://i0.wp.com/blog.sqlauthority.com/wp-content/uploads/2019/03/limittext.jpg?resize=350%2C200&ssl=1)
SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length - SQL Authority with Pinal Dave
![SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length - SQL Authority with Pinal Dave SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length - SQL Authority with Pinal Dave](https://i0.wp.com/blog.sqlauthority.com/wp-content/uploads/2018/12/col_length.jpg?resize=350%2C200&ssl=1)