SQL Server Performance

Handling KB Articles (Doc or PDF) with SQL Server 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by sqlderby, Sep 14, 2012.

  1. sqlderby Member

    Hi All

    I need to search relevant product KB articles and articles could be in word doc, PDF or HTML format with images. I want to know best way to design the database to handle these documents without impact the performance issue. I have read the articles on the this and there are couple of suggestions.

    Pls help me so I can choose best method. Pls also refer sites, articles or white papers so I can read them.

    Thanks !!!
  2. FrankKalis Moderator

    There is no single ultimate answer to this question. It can only be evaluated on a case by case basis. You need to consider size and number of documents, frequency of modifications or whether they are read-only, etc... This will influence your decision whether to put them into SQL Server or onto the filesystem or into a completely different document system.

Share This Page