{"id":5381,"date":"2015-08-28T09:00:06","date_gmt":"2015-08-28T07:00:06","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/"},"modified":"2015-08-28T09:00:06","modified_gmt":"2015-08-28T07:00:06","slug":"sql-server-2016-the-time-travel-with-temporal-table-part-iv","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/","title":{"rendered":"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV"},"content":{"rendered":"<h2><\/h2>\n<h2>Maintenance &amp; Metadata<\/h2>\n<p>My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata.<br \/>\nI divide my article into 4 parts to be clearer and easier to read:<br \/>\n<a title=\"Part I - Principle &amp; Creation\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-i\/\" target=\"_blank\">Part I \u2013 Principle &amp; Creation<\/a><br \/>\n<a title=\"Part II \u2013 INSERT, UPDATE &amp; DELETE commands\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-ii\/\" target=\"_blank\">Part II \u2013 INSERT, UPDATE &amp; DELETE commands<\/a><br \/>\n<a title=\"Part III \u2013 SELECT command\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iii\/\" target=\"_blank\">Part III \u2013 SELECT command<\/a><br \/>\n<a title=\"Part IV \u2013 Maintenance &amp; Metadata\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/\" target=\"_blank\">Part IV \u2013 Maintenance &amp; Metadata<\/a><\/p>\n<p>SQL Server version\/built used for this serie of articles is <strong>CTP 2.2\/13.0.407.1<\/strong><\/p>\n<h3>Backup &amp; Restore<\/h3>\n<p>Before my Backup, I run a database integrity Check with DBCC CHECKDB<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal48.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3365 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal48.png\" alt=\"temporal48\" width=\"300\" height=\"292\" \/><\/a><br \/>\nThe check go through the History table.<br \/>\nA traditional Backup from your database, stores the table and its history table.<br \/>\nI don\u2019t see any option to have a backup just from the table and not include the history table.<br \/>\nThe restore process like the backup process, restores both tables.<\/p>\n<h3>Index Rebuild &amp; Reorg<\/h3>\n<p>The first step is to see if the clustered index from History table is in the fragmentation view.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3358 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40.png\" alt=\"temporal40\" width=\"300\" height=\"189\" \/><\/a><br \/>\nCool, I see it!<br \/>\nTo be sure that I can see all indexes that I create on the history table, I create a new Non-Clustered Index and rerun the query<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal41.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3359 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal41.png\" alt=\"temporal41\" width=\"300\" height=\"165\" \/><\/a><br \/>\nThe next step is to verify if I can Rebuild or Reorganize indexes in the History table.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal42.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3360 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal42.png\" alt=\"temporal42\" width=\"300\" height=\"136\" \/><\/a><br \/>\nIt\u2019s running perfectly good:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal43.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3361 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal43.png\" alt=\"temporal43\" width=\"300\" height=\"141\" \/><\/a><br \/>\nI\u2019m sorry for my sample, while I haven\u2019t enough fragmentation to complete totally the test.<\/p>\n<h3>Metadata<\/h3>\n<h4>sys.tables<\/h4>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal45.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3362 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal45.png\" alt=\"temporal45\" width=\"300\" height=\"143\" \/><\/a><br \/>\nSys.tables has 3 new columns for temporal table:<\/p>\n<ul>\n<li>temporal_type with 0 for a standard table, 1 for the history table and 2 for the system-versioned table<\/li>\n<li>temporal_type_desc with the description of the 3 types from the column temporal_type<\/li>\n<li>history_table_id is an id for the system-versioned table.<\/li>\n<\/ul>\n<h4>sys.periods<\/h4>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal46.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3363 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal46.png\" alt=\"temporal46\" width=\"300\" height=\"133\" \/><\/a><br \/>\nSys.periods gives you the information about the start and end dates and times columns in your system-versioned table.<br \/>\nMSDN reference for sys.periods <a title=\"MSDN link to sys.periods\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt130702.aspxhttp:\/\/\" target=\"_blank\">here<\/a><\/p>\n<h4>Property \u201cTableTemporalType\u201c in OBJECTPROPERTYEX<\/h4>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal47.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-3364 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal47.png\" alt=\"temporal47\" width=\"300\" height=\"237\" \/><\/a><br \/>\nMy last is point is the new property TableTemporalType in OBJECTPROPERTYEX who precise the type of the table like temporal_type in the sys.tables<\/p>\n<h2>CORE MESSAGE<\/h2>\n<ul>\n<li>Maintenance Plan (Backup\/Restore, Index rebuild\/Reorg, Integrity check) goes through the system-versioned table and history table like a standard table.<\/li>\n<li>Sys.tables has 3 new columns for temporal table: temporal_type, temporal_type_desc and history_table_id.<\/li>\n<li>Sys.periods is a new metatdata to see which defines the period in the system-versioned table.<\/li>\n<\/ul>\n<h3>MORE INFORMATION<\/h3>\n<ul>\n<li>Msdn for Temporal Table <a title=\"MSDN link to temporal Table\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn935015%28v=sql.130%29.aspx\" target=\"_blank\">here<\/a><\/li>\n<li>A 20 minutes video is available on Channel9 <a title=\"Temporal Table Video from microsoft\" href=\"https:\/\/channel9.msdn.com\/Shows\/Data-Exposed\/Temporal-in-SQL-Server-2016\" target=\"_blank\">here<\/a><\/li>\n<\/ul>\n<p>This finishes my series of articles on this very good new feature in SQL Server 2016. Enjoy to use it!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Maintenance &amp; Metadata My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata. I divide my article into 4 parts to be clearer and easier to read: Part I \u2013 Principle &amp; Creation Part II \u2013 INSERT, UPDATE &amp; DELETE commands Part III \u2013 SELECT command Part IV \u2013 Maintenance &amp; [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":5390,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[49,51,566,625],"type_dbi":[],"class_list":["post-5381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-microsoft","tag-sql-server","tag-sql-server-2016","tag-temporal-table"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016: the Time Travel with temporal table \u2013 Part IV - dbi Blog<\/title>\n<meta name=\"description\" content=\"My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata for temporal table in SQL Server 2016\" \/>\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.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV\" \/>\n<meta property=\"og:description\" content=\"My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata for temporal table in SQL Server 2016\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-28T07:00:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"593\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\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.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV\",\"datePublished\":\"2015-08-28T07:00:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/\"},\"wordCount\":428,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/temporal40-1.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2016\",\"Temporal Table\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/\",\"name\":\"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/temporal40-1.png\",\"datePublished\":\"2015-08-28T07:00:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"My last chapter is about the maintenance backup\\\/restore, index rebuild\\\/reorg., etc. and the Metadata for temporal table in SQL Server 2016\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/temporal40-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/temporal40-1.png\",\"width\":940,\"height\":593},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV - dbi Blog","description":"My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata for temporal table in SQL Server 2016","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.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV","og_description":"My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata for temporal table in SQL Server 2016","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/","og_site_name":"dbi Blog","article_published_time":"2015-08-28T07:00:06+00:00","og_image":[{"width":940,"height":593,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV","datePublished":"2015-08-28T07:00:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/"},"wordCount":428,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40-1.png","keywords":["Microsoft","SQL Server","SQL Server 2016","Temporal Table"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/","name":"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40-1.png","datePublished":"2015-08-28T07:00:06+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"My last chapter is about the maintenance backup\/restore, index rebuild\/reorg., etc. and the Metadata for temporal table in SQL Server 2016","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/temporal40-1.png","width":940,"height":593},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-the-time-travel-with-temporal-table-part-iv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: the Time Travel with temporal table \u2013 Part IV"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5381"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5381\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5390"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5381"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}