Results 1 to 3 of 3

Thread: column size for ntext

  1. 08-11-2005, 06:45 AM #1
    lenakarthik@yah
    lenakarthik@yah is offline Registered User
    Join Date
    Jan 2005
    Location
    chennai
    Posts
    16

    column size for ntext

    Hi,

    Please help me to find out the ntext column size in a table.

    Thanks in advance

    Regards

    Karthik
    Reply With Quote Reply With Quote
  2. 08-11-2005, 07:49 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can find the actual space used from sysindexes table. Look for indid=255
    Reply With Quote Reply With Quote
  3. 08-11-2005, 02:54 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Sysindexes tells you how many pages used for ntaxt, taxt and image colunms in the table. You may need divide the number of pages by row counts and number of those kind of columns in the table to get rough idea of average column length of those columns.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules