{"id":133,"date":"2012-04-16T10:41:04","date_gmt":"2012-04-16T10:41:04","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/04\/16\/what-is-the-maximum-batch-size-in-sql-server\/"},"modified":"2012-04-16T10:41:04","modified_gmt":"2012-04-16T10:41:04","slug":"what-is-the-maximum-batch-size-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/04\/16\/what-is-the-maximum-batch-size-in-sql-server\/","title":{"rendered":"What is the Maximum Batch size in SQL Server?"},"content":{"rendered":"<p>table.hovertable {<br \/>\nfont-family: verdana,arial,sans-serif;<br \/>\nfont-size:11px;<br \/>\ncolor:#333333;<br \/>\nborder-width: 1px;<br \/>\nborder-color: #999999;<br \/>\nborder-collapse: collapse;<br \/>\n}<br \/>\ntable.hovertable th {<br \/>\nbackground-color:#c3dde0;<br \/>\nborder-width: 1px;<br \/>\npadding: 8px;<br \/>\nborder-style: solid;<br \/>\nborder-color: #a9c6c9;<br \/>\n}<br \/>\ntable.hovertable tr {<br \/>\nbackground-color:#d4e3e5;<br \/>\n}<br \/>\ntable.hovertable td {<br \/>\nborder-width: 1px;<br \/>\npadding: 8px;<br \/>\nborder-style: solid;<br \/>\nborder-color: #a9c6c9;<br \/>\n}<\/p>\n<p><strong>What is the Maxmum Batch size in SQL Server?<\/strong><br \/>\nSQL Server supports a batch size equal to  65536 * Network Packet Size.<\/p>\n<p>If X is the Network Packet Size then the Maxmum Batch size supported by SQL Server would be 65536 * X.<\/p>\n<p>Maxmum Batch size in SQL Server:<\/p>\n<table class=\"hovertable\">\n<tbody>\n<tr align=\"center\">\n<th>Max Capacity For<\/th>\n<th>SQL Server 2012<\/th>\n<th>SQL Server 2008 R2<\/th>\n<th>SQL Server 2008<\/th>\n<th>SQL Server 2005<\/th>\n<\/tr>\n<tr>\n<td>\nMaxmum Batch size in SQL Server\n<\/td>\n<td>\n65536 * Network Packet Size\n<\/td>\n<td>\n65536 * Network Packet Size\n<\/td>\n<td>\n65536 * Network Packet Size\n<\/td>\n<td>\n65536 * Network Packet Size\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432.aspx<\/a><br \/>\n<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432(v=sql.105).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432(v=sql.105).aspx<\/a><br \/>\n<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432(v=sql.100).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432(v=sql.100).aspx<\/a><br \/>\n<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432(v=sql.90).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432(v=sql.90).aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/133"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}