I have a database that has been in use for a number of years and up to this point we have been storing images (both a full size version and a smaller thumbnail) on the file system. In an effort to improve speed further, we recently moved the thumbnail images (which are only 200 pixels wide) to a varbinary(MAX) column in the database. There are about 40,000 pictures.

I have a database that has been in use for a number of years and up to this point we have been storing images (both a full size version and a smaller thumbnail) on the file system. In an effort to improve speed further, we recently moved the thumbnail images (which are only 200 pixels wide) to a varbinary(MAX) column in the database. There are about 40,000 pictures.

I have a database that has been in use for a number of years and up to this point we have been storing images (both a full size version and a smaller thumbnail) on the file system. In an effort to improve speed further, we recently moved the thumbnail images (which are only 200 pixels wide) to a varbinary(MAX) column in the database. There are about 40,000 pictures.

I have a database that has been in use for a number of years and up to this point we have been storing images (both a full size version and a smaller thumbnail) on the file system. In an effort to improve speed further, we recently moved the thumbnail images (which are only 200 pixels wide) to a varbinary(MAX) column in the database. There are about 40,000 pictures.

I have a database that has been in use for a number of years and up to this point we have been storing images (both a full size version and a smaller thumbnail) on the file system. In an effort to improve speed further, we recently moved the thumbnail images (which are only 200 pixels wide) to a varbinary(MAX) column in the database. There are about 40,000 pictures.

Closed 40 mins ago.

Closed 40 mins ago.

Closed 40 mins ago.

Closed 40 mins ago.

There were some tables without clustered index that, after some time, a clustered index was created on them.