storing files inside SQL Server

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  March 18, 2005 at 8:40 am

  #92637

  Go on then, lets kick of the debate...

  Is it more efficient (from a performance point of view) to store files as BLOBs inside a SQL Server database or is it better to store them in the windows file system and have a link to the file in the database?

  Talk about opening a can of worms

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 18, 2005 at 9:28 am

  #547813

  This subject was in discussed in this forum just a couple of weeks ago.  Check this: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=165246

  Greg

  Greg

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  March 18, 2005 at 9:30 am

  #547817

  that'll teach me to have a look through the old stuff first

  Thanks Greg