Post reply

Finding rows in a table with the most data

  • February 9, 2018 at 3:20 am

    #336089

    We have a situation where an audit table was corrupted by software for a while where the notes column ended up with huge amounts of data written to it by mistake.  It's a table with millions of rows and 156gb and I need to identify the records that have the most data and delete them. Is there any way of identifying those rows with the most data?

  • February 9, 2018 at 9:34 am

    #1979269

    What is the data type of the column containing the large amount of text?

  • February 9, 2018 at 10:33 am

    #1979276

    It's a data type of Text

  • February 9, 2018 at 10:43 am

    #1979277

    SELECT DataLength(textColumn) DLength
    order by DataLength(textColumn) DESC;

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply