SET STATISTICS IO ON does pretty much what you would expect, it returns information about IO back to your UI as a message. Why is this important? Well it helps you to understand just how much IO has been performed broken down by object. It actually breaks it down further than that, but we’ll cover that once we’ve seen how it works.
- SQL Versions