table.hovertable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #999999;
border-collapse: collapse;
}
table.hovertable th {
background-color:#c3dde0;
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
table.hovertable tr {
background-color:#d4e3e5;
}
table.hovertable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
What is the Maxmum Batch size in SQL Server?
SQL Server supports a batch size equal to 65536 * Network Packet Size.
If X is the Network Packet Size then the Maxmum Batch size supported by SQL Server would be 65536 * X.
Maxmum Batch size in SQL Server:
Max Capacity For | SQL Server 2012 | SQL Server 2008 R2 | SQL Server 2008 | SQL Server 2005 |
---|---|---|---|---|
Maxmum Batch size in SQL Server | 65536 * Network Packet Size | 65536 * Network Packet Size | 65536 * Network Packet Size | 65536 * Network Packet Size |
http://msdn.microsoft.com/en-us/library/ms143432.aspx
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.100).aspx
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.90).aspx