{"id":987,"date":"2022-06-05T14:54:47","date_gmt":"2022-06-05T06:54:47","guid":{"rendered":"https:\/\/cleardatascience.com\/?p=987"},"modified":"2022-06-05T14:57:54","modified_gmt":"2022-06-05T06:57:54","slug":"microsoft-sql-server-performance-tuning","status":"publish","type":"post","link":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/","title":{"rendered":"Microsoft SQL Server Performance Tuning"},"content":{"rendered":"

There are thousands of companies using Microsoft SQL Server database for their OLTP and OLAP operations.\u00a0 In recent years, many of them are facing serious performance issue with the rapid growth of data volume.\u00a0 If your database is more than 6TB in size or 1 table with more than 300GB, you are likely listening to complaints by users every day.<\/span>\u00a0<\/span><\/p>\n

With our expertise in handling data for years, we are helping clients to improve their database performance.\u00a0 To take an example in a fortune 500 corporation, we have a client with a SQL database more than 10TB in size.\u00a0 Some of their SQL queries and stored procedures were running for more than 60 minutes.<\/span>\u00a0<\/span><\/p>\n

To improve the performance, we have carried a number of tasks:<\/span><\/p>\n

    \n
  1. recommend the changes of storage arrangement.<\/span><\/li>\n
  2. Rewrite some SQL queries and sub-queries<\/span><\/li>\n
  3. Apply partition tables for those needed<\/span><\/li>\n
  4. Apply compression on tables necessary<\/span><\/li>\n<\/ol>\n

    There are 2 examples below to compare the performance before and after our tuning tasks.<\/span><\/p>\n\n\n\n\n\n
    Tasks<\/strong><\/td>\nBefore changes<\/strong><\/td>\nAfter changes<\/strong><\/td>\n<\/tr>\n
    SQL Query 1<\/td>\n01:02:35<\/td>\n00:23:04<\/td>\n<\/tr>\n
    Stored Procedure 1<\/td>\n02:16:46<\/td>\n01:12:45<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    For the tuning above, there is no additional investment in hardware like buying more rams and CPUs.<\/span><\/p>\n

    If you are facing such a problem, talk to us<\/a>.\u00a0 Our consultants are focused on data management and data science for years and provide different data and analytics solutions.<\/p>\n","protected":false},"excerpt":{"rendered":"

    There are thousands of companies using Microsoft SQL Server database for their OLTP and OLAP operations.\u00a0 In recent years, many […]<\/p>\n","protected":false},"author":1,"featured_media":989,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"nf_dc_page":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[6],"tags":[105,101,103,104,106,107,102],"class_list":["post-987","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cds-news","tag-database","tag-microsoft","tag-mssql","tag-performance-tuning","tag-slow","tag-sql-query","tag-sql-server"],"acf":[],"yoast_head":"\nMicrosoft SQL Server Performance Tuning - Clear Data Science Limited<\/title>\n<meta name=\"description\" content=\"We are helping clients to improve their database performance by taking difference tuning tasks. It is not limited to MSSQL but also other DB.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server Performance Tuning - Clear Data Science Limited\" \/>\n<meta property=\"og:description\" content=\"We are helping clients to improve their database performance by taking difference tuning tasks. It is not limited to MSSQL but also other DB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/\" \/>\n<meta property=\"og:site_name\" content=\"Clear Data Science Limited\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cleardatasciencelimited\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-05T06:54:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-05T06:57:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cleardatascience.com\/wp-content\/uploads\/2022\/06\/SQL_performance-005.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"380\" \/>\n\t<meta property=\"og:image:height\" content=\"337\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#\\\/schema\\\/person\\\/06529788d7f95b5acac977cf15b07d89\"},\"headline\":\"Microsoft SQL Server Performance Tuning\",\"datePublished\":\"2022-06-05T06:54:47+00:00\",\"dateModified\":\"2022-06-05T06:57:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/\"},\"wordCount\":219,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/SQL_performance-005.gif\",\"keywords\":[\"Database\",\"Microsoft\",\"MSSQL\",\"Performance Tuning\",\"slow\",\"SQL query\",\"SQL Server\"],\"articleSection\":[\"CDS News\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/\",\"name\":\"Microsoft SQL Server Performance Tuning - Clear Data Science Limited\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/SQL_performance-005.gif\",\"datePublished\":\"2022-06-05T06:54:47+00:00\",\"dateModified\":\"2022-06-05T06:57:54+00:00\",\"description\":\"We are helping clients to improve their database performance by taking difference tuning tasks. It is not limited to MSSQL but also other DB.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/SQL_performance-005.gif\",\"contentUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/SQL_performance-005.gif\",\"width\":380,\"height\":337},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/microsoft-sql-server-performance-tuning\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft SQL Server Performance Tuning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#website\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/\",\"name\":\"Clear Data Science Limited\",\"description\":\"Clear Data Clear Picture\",\"publisher\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#organization\",\"name\":\"Clear Data Science Limited\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/CDS-Logo-small-h02.png\",\"contentUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/CDS-Logo-small-h02.png\",\"width\":165,\"height\":45,\"caption\":\"Clear Data Science Limited\"},\"image\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/cleardatasciencelimited\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/16194855\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCS3jQw-3EZvmWkLr8ZyDHFw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#\\\/schema\\\/person\\\/06529788d7f95b5acac977cf15b07d89\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c3aad60a0de4528a5822f5362ebf40a45345a6f6670b6222da23f3930722bf74?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c3aad60a0de4528a5822f5362ebf40a45345a6f6670b6222da23f3930722bf74?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c3aad60a0de4528a5822f5362ebf40a45345a6f6670b6222da23f3930722bf74?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/author\\\/archsolutionltd\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft SQL Server Performance Tuning - Clear Data Science Limited","description":"We are helping clients to improve their database performance by taking difference tuning tasks. It is not limited to MSSQL but also other DB.","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:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft SQL Server Performance Tuning - Clear Data Science Limited","og_description":"We are helping clients to improve their database performance by taking difference tuning tasks. It is not limited to MSSQL but also other DB.","og_url":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/","og_site_name":"Clear Data Science Limited","article_publisher":"https:\/\/www.facebook.com\/cleardatasciencelimited\/","article_published_time":"2022-06-05T06:54:47+00:00","article_modified_time":"2022-06-05T06:57:54+00:00","og_image":[{"width":380,"height":337,"url":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2022\/06\/SQL_performance-005.gif","type":"image\/gif"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#article","isPartOf":{"@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/"},"author":{"name":"admin","@id":"https:\/\/cleardatascience.com\/zh-hant\/#\/schema\/person\/06529788d7f95b5acac977cf15b07d89"},"headline":"Microsoft SQL Server Performance Tuning","datePublished":"2022-06-05T06:54:47+00:00","dateModified":"2022-06-05T06:57:54+00:00","mainEntityOfPage":{"@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/"},"wordCount":219,"commentCount":0,"publisher":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#organization"},"image":{"@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#primaryimage"},"thumbnailUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2022\/06\/SQL_performance-005.gif","keywords":["Database","Microsoft","MSSQL","Performance Tuning","slow","SQL query","SQL Server"],"articleSection":["CDS News"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/","url":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/","name":"Microsoft SQL Server Performance Tuning - Clear Data Science Limited","isPartOf":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#primaryimage"},"image":{"@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#primaryimage"},"thumbnailUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2022\/06\/SQL_performance-005.gif","datePublished":"2022-06-05T06:54:47+00:00","dateModified":"2022-06-05T06:57:54+00:00","description":"We are helping clients to improve their database performance by taking difference tuning tasks. It is not limited to MSSQL but also other DB.","breadcrumb":{"@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#primaryimage","url":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2022\/06\/SQL_performance-005.gif","contentUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2022\/06\/SQL_performance-005.gif","width":380,"height":337},{"@type":"BreadcrumbList","@id":"https:\/\/cleardatascience.com\/en\/microsoft-sql-server-performance-tuning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cleardatascience.com\/en\/"},{"@type":"ListItem","position":2,"name":"Microsoft SQL Server Performance Tuning"}]},{"@type":"WebSite","@id":"https:\/\/cleardatascience.com\/zh-hant\/#website","url":"https:\/\/cleardatascience.com\/zh-hant\/","name":"Clear Data Science Limited","description":"Clear Data Clear Picture","publisher":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cleardatascience.com\/zh-hant\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cleardatascience.com\/zh-hant\/#organization","name":"Clear Data Science Limited","url":"https:\/\/cleardatascience.com\/zh-hant\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cleardatascience.com\/zh-hant\/#\/schema\/logo\/image\/","url":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/03\/CDS-Logo-small-h02.png","contentUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/03\/CDS-Logo-small-h02.png","width":165,"height":45,"caption":"Clear Data Science Limited"},"image":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/cleardatasciencelimited\/","https:\/\/www.linkedin.com\/company\/16194855","https:\/\/www.youtube.com\/channel\/UCS3jQw-3EZvmWkLr8ZyDHFw"]},{"@type":"Person","@id":"https:\/\/cleardatascience.com\/zh-hant\/#\/schema\/person\/06529788d7f95b5acac977cf15b07d89","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c3aad60a0de4528a5822f5362ebf40a45345a6f6670b6222da23f3930722bf74?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c3aad60a0de4528a5822f5362ebf40a45345a6f6670b6222da23f3930722bf74?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3aad60a0de4528a5822f5362ebf40a45345a6f6670b6222da23f3930722bf74?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/cleardatascience.com\/en\/author\/archsolutionltd\/"}]}},"_links":{"self":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/posts\/987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/comments?post=987"}],"version-history":[{"count":1,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/posts\/987\/revisions"}],"predecessor-version":[{"id":991,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/posts\/987\/revisions\/991"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/media\/989"}],"wp:attachment":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/media?parent=987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/categories?post=987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/tags?post=987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}