SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Text field in same or different table?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

FruitBatInShades
Yak Posting Veteran

51 Posts

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

United Kingdom
12543 Posts

Posted - 07/21/2006 :  08:36:50  Show Profile  Visit nr's Homepage
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 - 07/26/2006 :  04:50:45  Show Profile
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?

Edited by - FruitBatInShades on 07/26/2006 05:24:45
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000