http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspxIs it possible to see LOB (large object) logical reads from STATISTICS IO output on a table with no LOB columns? I was asked this question today by someone who had spent a good fraction of their afternoon trying to work out why this was occurring – evenenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspx#33621Fri, 18 Feb 2011 19:30:32 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33621Roy Ernest<p>Very good blog. I had seen this behavior in our set up. Now I know why. Thanks.</p>http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspx#33622Fri, 18 Feb 2011 19:40:53 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33622Rob Volk<p>Instead of &quot;S&quot; meaning &quot;small&quot;, how about &quot;Silent&quot; Large-OBjects?</p>http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspx#33625Fri, 18 Feb 2011 20:39:45 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33625Paul White<p>Roy,</p> <p>Thanks for the feedback - I'm so glad you found this entry useful.</p> <p>Paul</p> http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspx#33626Fri, 18 Feb 2011 20:40:17 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33626Paul White<p>Hey Rob,</p> <p>Yeah :)</p> <p>Silent is about right!</p> <p>Cheers,</p> <p>Paul</p> http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspx#33684Tue, 22 Feb 2011 15:19:31 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33684Paul White: Page Free Space<p>There is much more to query tuning than reducing logical reads and adding covering nonclustered indexes.&amp;#160;</p> http://sqlblog.com/blogs/paul_white/archive/2011/02/19/i-see-no-lobs.aspx#33792Fri, 25 Feb 2011 22:06:43 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33792Paul White: Page Free Space<p>There is much more to query tuning than reducing logical reads and adding covering nonclustered indexes.</p>