Capacity limits for dedicated SQL pool in Azure Synapse Analytics

Shweta Barhate 21 Reputation points
2021-07-10T07:20:22.66+00:00

As per the information in Microsoft Learn on "Capacity limits for dedicated SQL pool in Azure Synapse Analytics", Database Objects section;
Dependent on column data type. Limit is 8000 for char data types, 4000 for nvarchar, or 2 GB for MAX data types; is there any way to store more than 4000 (nvarchar) characters using data type nvarchar(max)?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,342 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 76,511 Reputation points Microsoft Employee
    2021-07-12T13:00:35.587+00:00

    Hello @Shweta Barhate ,

    Welcome to the Microsoft Q&A platform.

    Character data types that are either fixed-size, nchar, or variable-size, nvarchar.

    113874-image.png

    nvarchar [ ( n | max ) ]
    Variable-size string data. n defines the string size in byte-pairs and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^30-1 characters (2 GB). The storage size is two times n bytes + 2 bytes.

    Here is a great Stack Overflow forum posts which addressing similar issue: SQL NVARCHAR and VARCHAR Limits and How does SQL Server store more than 4000 characters in NVARCHAR(max)?.

    Hope this helps. Do let us know if you any further queries.

    ---------------------------------------------------------------------------

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful