CSS SQL Server Engineers - MSDN Blogs - MSDN Blogs

A more dramatic difference is shown from a test I ran against a 1.3 trillion row table, without the fix. The estimated rows are 900 trillion with a memory grant size of 90GB. Prior to SQL Server 2014 you can leverage Jonathan’s advice and limit the DBCC c

blogs.msdn.com