title: How to deal with large amount of XML data in a SQL Server database
body: <p>In a table there are 10 columns and 2 of those columns store huge amounts of data. One column (<code>XML</code> datatype) stores XML data, another column (<code>NVARCHAR(MAX)</code>) stores JSON data. Each rows size around 1.4 MB. Moreover, when I am using a <code>SELECT</code> command it takes a lot of time (22 seconds) to load only one record</p>
  
  <pre><code>TABLE - [dbo].[CampaignConfiguration](
  [CampaignId] [uniqueidentifier] NOT NULL,
  [ConfigurationXml] [xml] NOT NULL,
  [ConfigurationRules] [nvarchar](max) NOT NULL,
  [RulesVersion] [nvarchar](50) NULL,
  [Created] [datetime] NOT NULL,
  [CampaignCalculationParameters] [nvarchar](max) NULL 
  
  
  Select * 
  From CampaignConfiguration
  Where campaignid = 'EB5C2CDB-C076-5174-61D1-D9EA0E04975A';
  </code></pre>
  
  <p>Is there any better way to deal with to improve <code>SELECT</code> query performance?</p>