There is a need in our project to store wav files associated with a particulat type of event ocurring. What is the best way to store such files in SQL ?
Your choices are to store the file in the file system and the name of the file in the db, or put the whole file into a blob. Do a search on the site for blob you should find several other threads. I like putting stuff in the db, most people like to use the file system. Steve Jones recommends (and I mostly agree!) that if you go with blobs you should put them in a separate db to decrease backup/restore time of the main data.