Skip to content

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, Linux and PostgreSQL etc…

  • Home
  • SQL Server
    • Administration
    • Diagnostics
    • Performance
    • Security
    • T-SQL
    • Tools
  • PowerShell
    • Remoting
    • Tools
  • Linux
  • .Net Development
    • Visual Studio
    • C#
    • MVC
    • ASP.NET
  • Servers
    • IIS
    • SharePoint
    • Hyper-V
    • MSMQ
  • Windows

Why use of VARCHAR(MAX) should be avoided

Nov 9, 2015
Lincoln Bovee'

Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N):

Performance comparison of varchar(max) vs. varchar(N)

Views – 2481

Posted in Architecture, Design, Performance, Queries, SQL Server

Recent Posts

  • About TempDB and the Version Store 07/16/2019
  • Using PowerShell to Failover Availability Groups and WFC Cluster Nodes 05/21/2019
  • About Availability Groups Database Seeding 04/19/2019
  • About Collations in SQL Server 04/10/2019
  • PostgreSQL vs. SQL Server Notes 02/13/2019
  • Restoring a database using STOPATMARK 01/11/2019
  • Availability Groups: Things to remember 12/07/2018
  • Properly Taking a Cluster Offline for Disk Maintenance 08/14/2018
  • Building an AlwaysOn Availability Group SQL Cluster 03/07/2018
  • Some database design guidelines and best practices 01/29/2018

RSS Paul Randal’s Blog

RSS MSN PowerShell Blog

  • PowerShell is now notarized and hardened for macOS 05/21/2026 Jason Helmick
  • PowerShell PSResource Roadmap and Best Practices 05/20/2026 Sydney Smith
  • Announcing Microsoft Desired State Configuration v3.2.0 04/29/2026 Jason Helmick
  • PowerShell MSI package deprecation and preview updates 04/10/2026 Jason Helmick
  • PowerShell 7.6 release postmortem and investments 04/01/2026 Jason Helmick
Powered by Newp WordPress Theme. © 2026 LincolnBlog.net. All Rights Reserved.