SQL Server: data tab and IMAGE columns

kalvaro's profile image kalvaro posted 9 years ago in General Permalink
Anse, just a quick report for whenever you have some spare time. When you open the "Data" tab of a SQL Server table which has a column of type IMAGE it seems to retrieve the complete field value. Here's the log entry:

SELECT TOP 1000 * FROM "foo"."dbo"."bar";


That means that as soon as you have a few MB worth of data the tab takes ages to load and HeidiSQL gets unresponsive afterwards. (Right now it was using as much memory as Firefox and I only have one row with a 40 MB picture. When I finally managed to focus on another table memory usage dropped.)
kalvaro's profile image kalvaro posted 9 years ago Permalink

Just a little bump. I don't know how HeidiSQL deals with BLOB columns in MySQL (never had the chance to use it) but the software is unusable in SQL Server when such columns are involved, e.g.:

CREATE TABLE test(
    test_id INT IDENTITY(1, 1) NOT NULL,
    some_binary_data IMAGE,

    CONSTRAINT test_pk PRIMARY KEY (test_pk)
);

Please login to leave a reply, or register at first.