For a nonclustered index key, the maximum is 1700 bytes. The maximum number of bytes in a clustered index key cannot exceed 900 in SQL Server. Before SQL Server 2016, all versions supported 900 bytes for all index types. ![]() The default packet size is 4 KB, and is controlled by the network packet size configuration option.īyte length of a string containing Transact-SQL statements (batch size)ĩ00 bytes for a clustered index. Network packet size is the size of the tabular data stream (TDS) packets used to communicate between applications and the relational Database Engine. Maximum sizes/numbers SQL Server (64-bit) Maximum sizes and numbers of various objects defined in SQL Server databases or referenced in Transact-SQL statements. Check parameters for system configuration checker. ![]()
0 Comments
Leave a Reply. |