image to ssql server

hi i have a question about images in sql server. is it useful to store images in binary format in sql server or not. maybe this method is better than to sore images somewhere in the server, but i don't know mabe it uses more space or slows getting that images from sql server.

The answer is it depends, there are basically 2 schools of though on this.

1/ Store the whole thing in the database, lots of mapping software does this, but maps are made up of lots of small images and the data access pattern uses SQL Queries pretty intensively. This also works well if you want a single place for backup/restore, security etc.

2/ Store metadata in SQL Server with pointers to the images in the file system, this is likely better where the images are bigger etc.