StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5252701
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-03-09T21:58:24.920
FavoriteCount
0
LastActivityDate
2011-03-10T15:28:09.690
LastEditDate
2011-03-10T15:28:09.690
LastEditorUserId
50031
OwnerUserId
50031
ParentId
5251101
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
<p>There isn't one right answer here but one consideration is if volume of data will be a problem. If it's not too large I prefer to keep them in the database for the same reason I like to have a database with backups, consistency and recoverability of my data. If you use file system, or even filestream you do not back up your pdf when you backup your database, and if you restore to another server or rollback to a previous point in time you may end up with your pdfs and your data in inconsistent states. Sure it will perform better and you should definitely keep that in mind but if performance isn't an issue it sure is nice to be able to restore a database to another server, even in development or test and know that you have all of your data, not all of your data EXCEPT your pdfs. </p> <p>UPDATE: Martin is correct, filestream data is backed up with your regular backups and you can use the WITH MOVE option when restoring to restore the data to a different location if needed. So to clarify, if you use plain old pointers to files on disk somewhere you will not have your pdfs backed up when you backup your database but you will if you use filestream. You still need to be careful that the files are not modified outside of the database since the database will no longer ensure integrity of your records, for example a user could delete the file off of the filesystem that the filestream is pointing too, or antivirus could quarantine the file if it was configured incorrectly. With a little planning filestream looks like a great option for many scenarios.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POStore .pdf in SQL or path?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USShane Delmore
UserOwnerUserId
1. USShane Delmore
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POStore .pdf in SQL or path?
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. CO["You can use all backup and recovery models with FILESTREAM data, and the FILESTREAM data is backed up with the structured data in the database"](http://technet.microsoft.com/en-us/library/bb933993.aspx)
  singulars
  PostPostId
  PO
  UserUserId
  USMartin Smith

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.