The max size for a column of type NVARCHAR(MAX)
is 2 GByte of storage.
Since NVARCHAR
uses 2 bytes per character, that’s approx. 1 billion characters.
Leo Tolstoj’s War and Peace is a 1’440 page book, containing about 600’000 words – so that might be 6 million characters – well rounded up. So you could stick about 166 copies of the entire War and Peace book into each NVARCHAR(MAX)
column.
Is that enough space for your needs? 🙂
Related Posts:
- sql query to return differences between two tables
- T-SQL split string
- An attempt was made to access a socket in a way forbidden by its access permissions
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- How to find sum of multiple columns in a table in SQL Server 2005?
- How can I delete using INNER JOIN with SQL Server?
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- How can I get column names from a table in SQL Server?
- MS SQL compare dates?
- MS SQL compare dates?
- How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
- Using RegEx in SQL Server
- Difference between database and schema
- How to format a numeric column as phone number in SQL
- How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
- How to select the last record of a table in SQL?
- Comma separated results in SQL
- SHOWPLAN permission denied in database ‘tempdb’. in sql server 2008
- Selecting COUNT(*) with DISTINCT
- Inserting multiple rows in a single SQL query? [duplicate]
- What do Clustered and Non-Clustered index actually mean?
- SQL query to select dates between two dates
- SQL query to get the employee name and their manager name from the same table
- How can I do an UPDATE statement with JOIN in SQL Server?
- Rename column SQL Server 2008
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- How to delete duplicate rows in SQL Server?
- The SQL OVER() clause – when and why is it useful?
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- SQL Query with NOT LIKE IN
- SQL Server IF EXISTS THEN 1 ELSE 2
- T-SQL split string based on delimiter
- SQL Query with SUM with Group By
- SQL Server Management Studio, how to get execution time down to milliseconds
- How do I perform an IF…THEN in an SQL SELECT?
- SQL update from one Table to another based on a ID match
- Each GROUP BY expression must contain at least one column that is not an outer reference
- How to drop all tables from a database with one SQL query?
- SQL Server : Arithmetic overflow error converting expression to data type int
- Optimistic vs. Pessimistic locking
- How to calculate percentage with a SQL statement
- The target principal name is incorrect. Cannot generate SSPI context
- Query comparing dates in SQL
- Best way to do nested case statement logic in SQL Server
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- BCP error “Unable to open BCP host data-file”
- How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
- The multi-part identifier could not be bound
- Query error with ambiguous column name in SQL
- SQL Server : error converting data type varchar to numeric
- How to drop all tables from a database with one SQL query?
- Sql Server string to date conversion
- Check if table exists in SQL Server
- Invalid length parameter passed to the LEFT or SUBSTRING function
- Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs
- How can I truncate a datetime in SQL Server?
- Why use a READ UNCOMMITTED isolation level?
- SQL Server Insert if not exists
- How can I import an Excel file into SQL Server?
- SQL Server: Invalid Column Name
- How to group by month from Date field using sql
- sql server invalid object name – but tables are listed in SSMS tables list
- SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
- Is there a combination of “LIKE” and “IN” in SQL?
- How to get a date in YYYY-MM-DD format from a TSQL datetime field?
- SQL Server String or binary data would be truncated
- Search text in stored procedure in SQL Server
- How to convert SQL Server’s timestamp column to datetime format
- Arithmetic overflow error converting expression to data type datetime. (while displaying date time..)
- Add a column with a default value to an existing table in SQL Server
- What represents a double in sql server?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- The SELECT permission was denied on the object ‘Users’, database ‘XXX’, schema ‘dbo’
- How do you open an SDF file (SQL Server Compact Edition)?
- Get size of all tables in database
- Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
- Microsoft OLE DB Provider for SQL Server error ‘80004005’
- Bulk load data conversion error (truncation)
- Why do table names in SQL Server start with “dbo”?
- ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
- How do I fix the multiple-step OLE DB operation errors in SSIS?
- SQL Server: Error converting data type nvarchar to numeric
- SQL – WHERE (X, Y) IN (A, B)
- How do I format a number with commas in T-SQL?
- Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
- Backup a single table with its data from a database in sql server 2008
- To add server using sp_addlinkedserver
- How to connect to a local database in SQL Server Management Studio?
- how to increment integer Columns value by 1 in SQL
- How can I group by date time column without taking time into consideration
- What are named pipes?
- SQL- Ignore case while searching for a string
- SQL WHERE.. IN clause multiple columns
- “select * into table” Will it work for inserting data into existing table
- Filter data based on date in sql
- CASE IN statement with multiple values
- Varchar invalid for Sum operator
- Using Excel VBA to run SQL query
- How to connect to database from Unity