Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Text field in same or different table?

Author  Topic 

FruitBatInShades
Yak Posting Veteran

51 Posts

Posted - 2006-07-21 : 08:23:54
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?

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-21 : 08:36:50
Depends on the text in row setting. Look at sp_tableoption
Look at text in row in bol.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

FruitBatInShades
Yak Posting Veteran

51 Posts

Posted - 2006-07-26 : 04:50:45
So by default SQL Server keeps blob info in a seperate place. So by creating seperate tables like (Page,PageContent) and joining at query time, I am gaining anything in performance?
Go to Top of Page
   

- Advertisement -