title: Arithmetic overflow on column sum in sql server
body: <p>I'm trying to get a column total but when i run this query i get the following error. Any advice?</p>
  
  <pre><code>SELECT SUM(Size) as total
  FROM  AllDocs
  Where DirName LIKE 'sites/test/test%'
  
  
  ERROR:
  Msg 8115, Level 16, State 2, Line 1
  Arithmetic overflow error converting expression to data type int.
  Warning: Null value is eliminated by an aggregate or other SET operation.
  </code></pre>