Does keeping the text field in a different table help performance?
I am working on a website system that has page content in text fields, some of which are quite big. I keep creating seperate tables for the text in the hope that it will improve performance. The reason being that the main table is scanned and filtered a lot.
Does SQL server keep the text content seperately anyway? Am I gaining anything using this approach?