title: Best way to store large data in SQL Server
body: <p>I have a news website created with ASP.NET MVC. </p>
  
  <p>Below is my table:</p>
  
  <pre><code>CREATE TABLE [dbo].[News] (
  [NewsID]         INT            IDENTITY (1, 1) NOT NULL,
  [InstitutionID]  INT            NOT NULL,
  [Title]          NVARCHAR (450) NOT NULL,
  [NewsDate]       DATETIME       NOT NULL,
  [Description]    NVARCHAR (MAX) NULL,
  [path]           NVARCHAR (MAX) NULL,
  [PostedBy]       NVARCHAR (MAX) NULL,
  [ContactPhone]   NVARCHAR (MAX) NULL,
  [ContactEmail]   NVARCHAR (MAX) NULL,
  [NewsExpiryDate] DATETIME       NOT NULL,
  CONSTRAINT [PK_dbo.News] PRIMARY KEY CLUSTERED ([NewsID] ASC),
  CONSTRAINT [FK_dbo.News_dbo.state_InstitutionID] FOREIGN KEY ([InstitutionID]) REFERENCES [dbo].[state] ([InstitutionID]) ON DELETE CASCADE );
  </code></pre>
  
  <p>I noticed that my database has increased to 8GB, and it is getting slower to load a page.</p>
  
  <p>I am thinking of storing the news in a file and then saving the path in database. </p>
  
  <p>Is there anyway I can convert the form value representing "[Description]" into a file and then store the path to my database?</p>