Conclusion
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
| To | Do this |
|---|---|
| Start SQL Server Management Studio | From the Start Menu, select ... |
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
