You can see that there is no single right answer to the question of where to store your data. However, Microsoft has made significant improvements in the database engine so that you can store more types of data more efficiently. If you need to store XML data, you should seriously consider using the new built in XML datatype because of the functionality it offers. SQL Server can also handle other types of application files that you may need for tracking application data, incuding settings files. You should be able to use what you have learned in this chapter to make sound decisions on data-storage locations when designing your application. Chapter 1 Quick Reference
|