{"id":610,"date":"2017-10-02T11:17:55","date_gmt":"2017-10-02T16:17:55","guid":{"rendered":"https:\/\/www.baronsoftware.com\/Blog\/?p=610"},"modified":"2017-10-02T11:17:55","modified_gmt":"2017-10-02T16:17:55","slug":"purge-microsoft-sql-email-items","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/","title":{"rendered":"How to purge Microsoft SQL email Items"},"content":{"rendered":"<h2 style=\"text-align: center;\">How to purge Microsoft SQL email Items<\/h2>\n<p><a href=\"http:\/\/www.microsoft.com\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" data-attachment-id=\"331\" data-permalink=\"https:\/\/www.baronsoftware.com\/Blog\/microsoft-killing-techrewards-learning-program\/microsofts-logo-gets-a-makeover\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?fit=1170%2C877&amp;ssl=1\" data-orig-size=\"1170,877\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"microsofts-logo-gets-a-makeover\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?fit=640%2C480&amp;ssl=1\" class=\"aligncenter wp-image-331 size-medium\" src=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?resize=300%2C225&#038;ssl=1\" alt=\"Purge\" width=\"300\" height=\"225\" srcset=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?resize=300%2C225&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?resize=768%2C576&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?resize=1024%2C768&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?w=1170&amp;ssl=1 1170w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be done every month to purge what is no longer necessary.\u00a0 SQL Server stores all mails and attachments in\u00a0<strong>msdb<\/strong>\u00a0database. To avoid unnecessary growth of\u00a0<strong>msdb\u00a0<\/strong>database you should remove these mail history unless it is required for auditing or other purposes.<\/p>\n<p>As always make sure you have your backups done prior to running any sort of removal in the event you did something incorrectly.\u00a0 By purging you are reducing the amount of wasted space in the msdb database that could be used for other things activities.<\/p>\n<p>Simply running the following statement using T-SQL you can check the amount of database mails that have been processed from the catalog msdb.dbo.sysmail_allitems.\u00a0 \u00a0There are 3 additional\u00a0 views which shows mails in their different statuses:\u00a0\u00a0<strong>sysmail_faileditems<\/strong>,\u00a0<strong>sysmail_unsentitems<\/strong><strong>\u00a0<\/strong>and\u00a0<strong>sysmail_sentitems<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>SELECT\u00a0 COUNT(*)\u00a0 FROM\u00a0 msdb.dbo.sysmail_allitems<\/strong><\/span><\/p>\n<p>You should get back the count of how many mail items are stored in the msdb.<\/p>\n<h2 style=\"text-align: center;\">How to delete mail<\/h2>\n<p>To delete mail items you can use system stored procedure\u00a0<strong>sysmail_delete_mailitems_sp<\/strong>, it has below syntax:<\/p>\n<p><em>sysmail_delete_mailitems_sp [@sent_before] [@sent_status]<\/em><\/p>\n<p>You can delete mail using either of the parameters,\u00a0<em><strong>@sent_before<\/strong><\/em>\u00a0deletes all mail that were sent before specified date, and\u00a0<em><strong>@sent_status\u00a0<\/strong><\/em>deletes all mails with specified status.<\/p>\n<p>For example, to delete all mails which are sent and are older than current month we can use:<\/p>\n<p>EXEC\u00a0\u00a0msdb.dbo.sysmail_delete_mailitems_sp<\/p>\n<p>@sent_before\u00a0=\u00a0&#8216;2017-05-10 00:00:00&#8217;,<\/p>\n<p>@sent_status\u00a0=\u00a0&#8216;sent&#8217;<\/p>\n<p>You can modify the @sent_before to do the following:<\/p>\n<pre><strong>DECLARE @PurgeDate datetime = dateadd(dd,-30,getdate());  <\/strong><\/pre>\n<p>@PurgeDate will be the date from 30 days or older which is a good idea to remove that or you can change it to<br \/>\n-10 for anything older than 10 days.<\/p>\n<p>So the statement would be<\/p>\n<pre><strong>EXEC\u00a0\u00a0msdb.dbo.sysmail_delete_mailitems_sp @sent_before=@PurgeDate;<\/strong><\/pre>\n<p>You may choose to only delete mail items that have been successfully sent.\u00a0 If that is the case then you can run the following code to delete your database mail based on the\u00a0<em>sent\u00ad_status<\/em>\u00a0of \u201csent\u201d.<\/p>\n<p>If you are not periodically deleting your mail then you might want to consider cleaning up old database mail that no longer has value.\u00a0 Determine what retention period you should use for your database mail.\u00a0 With your established retention period then just set up a SQL Agent job to purge your database mail based on your retention period.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to purge Microsoft SQL email Items There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be done every month to purge what is no longer necessary.\u00a0 SQL Server stores all mails and attachments in\u00a0msdb\u00a0database. To avoid unnecessary growth of\u00a0msdb\u00a0database you should remove these mail [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":[],"rop_publish_now_history":[],"rop_publish_now_status":"pending","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11,1],"tags":[21,39,7,47,15,49,37,6,36,34],"class_list":["post-610","post","type-post","status-publish","format-standard","hentry","category-pc-tips-bits-bytes","category-sql-tips","tag-computers","tag-dbartisan","tag-development","tag-idera","tag-microsoft","tag-microsoft-access","tag-rapid-sql","tag-software","tag-sql-server","tag-sqlite"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to purge Microsoft SQL email Items - Baron Software<\/title>\n<meta name=\"description\" content=\"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to purge Microsoft SQL email Items\" \/>\n<meta property=\"og:description\" content=\"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-02T16:17:55+00:00\" \/>\n<meta name=\"author\" content=\"richard@baronsoftware.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to purge Microsoft SQL email Items\" \/>\n<meta name=\"twitter:description\" content=\"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@Rbaroniunas\" \/>\n<meta name=\"twitter:site\" content=\"@Rbaroniunas\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"richard@baronsoftware.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"How to purge Microsoft SQL email Items\",\"datePublished\":\"2017-10-02T16:17:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/\"},\"wordCount\":421,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/microsofts-logo-gets-a-makeover-300x225.jpg\",\"keywords\":[\"computers\",\"DBArtisan\",\"Development\",\"Idera\",\"Microsoft\",\"MIcrosoft Access\",\"Rapid SQL\",\"Software\",\"SQL Server\",\"SQLite\"],\"articleSection\":[\"Computer PC Tips - bits and bytes\",\"SQL Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/\",\"name\":\"How to purge Microsoft SQL email Items - Baron Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/microsofts-logo-gets-a-makeover-300x225.jpg\",\"datePublished\":\"2017-10-02T16:17:55+00:00\",\"description\":\"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/microsofts-logo-gets-a-makeover.jpg?fit=1170%2C877&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/microsofts-logo-gets-a-makeover.jpg?fit=1170%2C877&ssl=1\",\"width\":1170,\"height\":877,\"caption\":\"Phone\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/purge-microsoft-sql-email-items\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to purge Microsoft SQL email Items\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\",\"name\":\"Baron Software\",\"description\":\"Highest Quality Software Developed.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\",\"name\":\"Baron Software\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i2.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i2.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1\",\"width\":1920,\"height\":400,\"caption\":\"Baron Software\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/Rbaroniunas\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\",\"name\":\"richard@baronsoftware.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"caption\":\"richard@baronsoftware.com\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to purge Microsoft SQL email Items - Baron Software","description":"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/","og_locale":"en_US","og_type":"article","og_title":"How to purge Microsoft SQL email Items","og_description":"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.","og_url":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/","og_site_name":"Baron Software","article_published_time":"2017-10-02T16:17:55+00:00","author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_title":"How to purge Microsoft SQL email Items","twitter_description":"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.","twitter_image":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg","twitter_creator":"@Rbaroniunas","twitter_site":"@Rbaroniunas","twitter_misc":{"Written by":"richard@baronsoftware.com","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"How to purge Microsoft SQL email Items","datePublished":"2017-10-02T16:17:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/"},"wordCount":421,"commentCount":0,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover-300x225.jpg","keywords":["computers","DBArtisan","Development","Idera","Microsoft","MIcrosoft Access","Rapid SQL","Software","SQL Server","SQLite"],"articleSection":["Computer PC Tips - bits and bytes","SQL Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/","url":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/","name":"How to purge Microsoft SQL email Items - Baron Software","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#primaryimage"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover-300x225.jpg","datePublished":"2017-10-02T16:17:55+00:00","description":"There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be created by an Admin.","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#primaryimage","url":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?fit=1170%2C877&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover.jpg?fit=1170%2C877&ssl=1","width":1170,"height":877,"caption":"Phone"},{"@type":"BreadcrumbList","@id":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"How to purge Microsoft SQL email Items"}]},{"@type":"WebSite","@id":"https:\/\/www.baronsoftware.com\/Blog\/#website","url":"https:\/\/www.baronsoftware.com\/Blog\/","name":"Baron Software","description":"Highest Quality Software Developed.","publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.baronsoftware.com\/Blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization","name":"Baron Software","url":"https:\/\/www.baronsoftware.com\/Blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/logo\/image\/","url":"https:\/\/i2.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/01\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1","contentUrl":"https:\/\/i2.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/01\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1","width":1920,"height":400,"caption":"Baron Software"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/Rbaroniunas"]},{"@type":"Person","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd","name":"richard@baronsoftware.com","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","caption":"richard@baronsoftware.com"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2e6qU-9Q","jetpack-related-posts":[{"id":928,"url":"https:\/\/www.baronsoftware.com\/Blog\/microsoft-sql-server-how-to-get-a-table-size\/","url_meta":{"origin":610,"position":0},"title":"Microsoft SQL Server how to get a table size","author":"richard@baronsoftware.com","date":"July 22, 2018","format":false,"excerpt":"Microsoft SQL Server how to get a table size Sometimes you need to get the size of a particular table located in a database within the Microsoft Server and the following query can provide you that.\u00a0 You can run this manually or place it in a stored procedure for numerous\u2026","rel":"","context":"In &quot;SQL Tips&quot;","block_context":{"text":"SQL Tips","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/sql-tips\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":245,"url":"https:\/\/www.baronsoftware.com\/Blog\/microsoft-bringing-sql-server-2016-linux\/","url_meta":{"origin":610,"position":1},"title":"Microsoft SQL Server 2016 is coming to Linux","author":"richard@baronsoftware.com","date":"March 8, 2016","format":false,"excerpt":"Microsoft SQL Server 2016 is coming to Linux will provide the ability for users to have the features and additional security. Click the image for more information about SQL Server Microsoft will be releasing a version of their SQL Server 2016 for Linux which is a major step in the\u2026","rel":"","context":"In &quot;Software development Concepts&quot;","block_context":{"text":"Software development Concepts","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-development-concepts\/"},"img":{"alt_text":"Percentage","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":677,"url":"https:\/\/www.baronsoftware.com\/Blog\/critical-sql-server-patches-meltdown-spectre\/","url_meta":{"origin":610,"position":2},"title":"Critical SQL Server Patches for Meltdown and Spectre","author":"richard@baronsoftware.com","date":"January 10, 2018","format":false,"excerpt":"Critical SQL Server Patches for Meltdown and Spectre There are two new possible viruses Meltdown and Spectre that can lead to dangerous situations on your SQL server by attacks. The following summary allows you to review and decide how to patch your systems.\u00a0 All SQL DBAs need to take action\u2026","rel":"","context":"In &quot;Microsoft Development&quot;","block_context":{"text":"Microsoft Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/microsoft-development\/"},"img":{"alt_text":"Microsoft SQL Server 2016","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/microsoft-sql-server-2016.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":157,"url":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/","url_meta":{"origin":610,"position":3},"title":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance","author":"richard@baronsoftware.com","date":"September 23, 2015","format":false,"excerpt":"Baron Software is proud to present \"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance\" webinar on September 24th, 2015 during the Embarcadero DataU webinar series. \u00a0Richard Baroniunas will discuss the benefits of using Rapid SQL to prepare SQL statements to use Windows Functions and\u2026","rel":"","context":"In &quot;Software Events&quot;","block_context":{"text":"Software Events","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-events\/"},"img":{"alt_text":"dbps icon 25x25","src":"https:\/\/i0.wp.com\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":443,"url":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","url_meta":{"origin":610,"position":4},"title":"Creating a Disaster Recovery Plan for your database (SQL)","author":"richard@baronsoftware.com","date":"February 15, 2017","format":false,"excerpt":"Creating a Disaster Recovery Plan for your database (SQL) \u00a0 Idera recently had a fantastic webinar that went over the creation of a disaster recovery plan concerning your databases. \u00a0This should be a high critical piece of work usually done by DBAs within a company. \u00a0Let's go over a simple\u2026","rel":"","context":"In &quot;Software development Concepts&quot;","block_context":{"text":"Software development Concepts","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-development-concepts\/"},"img":{"alt_text":"Idera","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":372,"url":"https:\/\/www.baronsoftware.com\/Blog\/baron-software-supports-db-powerstudio\/","url_meta":{"origin":610,"position":5},"title":"Baron Software Supports IDERA DB PowerStudio","author":"richard@baronsoftware.com","date":"October 28, 2016","format":false,"excerpt":"Baron Software Supports IDERA's DB PowerStudio Baron Software is a longtime user of IDERA's DB PowerStudio which assists us in dealing with our clients in maintaining thousands of mission-critical multi-platform databases that are used for data\u00a0warehouses along with highly robust data driven applications,\u201d said\u00a0Richard Baroniunas, software developer and DBA at\u2026","rel":"","context":"In &quot;Software Releases&quot;","block_context":{"text":"Software Releases","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-releases\/"},"img":{"alt_text":"Idera Powerstudio","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/comments?post=610"}],"version-history":[{"count":1,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":611,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/610\/revisions\/611"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}