{"id":1112,"date":"2007-12-31T20:53:00","date_gmt":"2007-12-31T20:53:00","guid":{"rendered":"\/blogs\/paul\/post\/Inside-the-Storage-Engine-When-do-versioning-tags-get-added.aspx"},"modified":"2007-12-31T20:53:00","modified_gmt":"2007-12-31T20:53:00","slug":"inside-the-storage-engine-when-do-versioning-tags-get-added","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/","title":{"rendered":"Inside the Storage Engine: When do versioning tags get added?"},"content":{"rendered":"


\n

Ok – so we did more partying than we thought so blog posts have been a little sparse this month, but here’s one to end off the year.<\/P>
\n

There’s a popular impression that turning on snapshot isolation and then rebuilding indexes will cause all rows in the table to get the extra 14-byte versioning tags. Fact or fiction? Let’s find out.<\/P>
\n

First I’ll create a test database, containing a small table with a clustered index and few rows:<\/P>
\n


\n

CREATE<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> SItest<\/FONT>;
<\/FONT><\/FONT>GO<\/P><\/FONT>
\n

USE<\/FONT><\/FONT> SItest<\/FONT>;
<\/FONT><\/FONT>GO<\/P><\/FONT>
\n

CREATE<\/FONT><\/FONT> <\/FONT>TABLE<\/FONT> SmallTable <\/FONT>(<\/FONT>c1 <\/FONT>INT<\/FONT>,<\/FONT> c2 <\/FONT>INT<\/FONT>);
<\/FONT><\/FONT>CREATE<\/FONT><\/FONT> <\/FONT>CLUSTERED<\/FONT> <\/FONT>INDEX<\/FONT> SmallTableCI <\/FONT>ON<\/FONT> SmallTable <\/FONT>(<\/FONT>c1<\/FONT>);
<\/FONT><\/FONT>GO<\/P><\/FONT>
\n

INSERT<\/FONT><\/FONT> <\/FONT>INTO<\/FONT> SmallTable <\/FONT>VALUES<\/FONT> <\/FONT>(<\/FONT>1<\/FONT>,<\/FONT> 1<\/FONT>);
<\/FONT><\/FONT>INSERT<\/FONT><\/FONT> <\/FONT>INTO<\/FONT> SmallTable <\/FONT>VALUES<\/FONT> <\/FONT>(<\/FONT>2<\/FONT>,<\/FONT>2<\/FONT>);
<\/FONT><\/FONT>GO<\/FONT><\/P><\/BLOCKQUOTE><\/FONT>
\n

Next I’ll turn on READ_COMMITTED_SNAPSHOT<\/FONT> and rebuild the index to see if statement level versioning does the trick:<\/P>
\n


\n

ALTER<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> SItest <\/FONT>SET<\/FONT> <\/FONT>READ_COMMITTED_SNAPSHOT<\/FONT> <\/FONT>ON<\/FONT><\/FONT>;
<\/FONT>GO<\/P><\/FONT><\/FONT>
\n

ALTER<\/FONT><\/FONT> <\/FONT>INDEX<\/FONT> SmallTableCI <\/FONT>ON<\/FONT> SmallTable <\/FONT>REBUILD<\/FONT><\/FONT>;
<\/FONT>GO<\/P><\/FONT><\/FONT><\/BLOCKQUOTE>
\n

Now let’s look at the data page holding the two rows to see if there’s any versioning info (the output is snipped short a little for brevity):<\/P>
\n


\n

DBCC<\/FONT><\/FONT> IND <\/FONT>(<\/FONT>SItest<\/FONT>,<\/FONT> SmallTable<\/FONT>,<\/FONT> 1<\/FONT>);
<\/FONT><\/FONT>GO<\/P><\/FONT>
\n

DBCC<\/FONT><\/FONT> TRACEON <\/FONT>(<\/FONT>3604<\/FONT>); — remember this makes the output go to the console<\/FONT>
<\/FONT><\/FONT>DBCC<\/FONT><\/FONT> PAGE <\/FONT>(<\/FONT>SItest<\/FONT>,<\/FONT> 1<\/FONT>,<\/FONT> 153<\/FONT>,<\/FONT> 3<\/FONT>);
<\/FONT><\/FONT>GO<\/FONT><\/P>
\n

PageFID PagePID     IAMFID IAMPID      ObjectID    IndexID
——- ———– —— ———– ———– ———–
1       154         NULL   NULL        2073058421  1
1       153         1      154         2073058421  1<\/FONT><\/P>
\n

(2 row(s) affected)<\/FONT><\/P>
\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/FONT><\/P>
\n

PAGE: (1:153)<\/FONT><\/P>
\n

<SNIP SNIP SNIP><\/FONT><\/P>
\n

Slot 0 Offset 0x60 Length 15<\/FONT><\/P>
\n

Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP
Memory Dump @0x6209C060<\/FONT><\/P>
\n

00000000:   10000c00 01000000 01000000 0300f9 ……………
UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 0 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 1<\/FONT><\/P>
\n

Slot 0 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 1<\/FONT><\/P>
\n

Slot 1 Offset 0x6f Length 15<\/FONT><\/P>
\n

Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP
Memory Dump @0x6209C06F<\/FONT><\/P>
\n

00000000:   10000c00 02000000 02000000 0300f9 ……………
UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 1 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 2<\/FONT><\/P>
\n

Slot 1 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 2<\/FONT><\/P>
\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/FONT><\/P><\/BLOCKQUOTE>
\n

Nope – both the rows look normal. Now for completeness let’s try transaction level versioning and a rebuild:<\/P>
\n


\n

ALTER<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> SItest <\/FONT>SET<\/FONT> <\/FONT>ALLOW_SNAPSHOT_ISOLATION<\/FONT> <\/FONT>ON<\/FONT><\/FONT>;
<\/FONT>GO<\/FONT><\/FONT><\/P>
\n

ALTER<\/FONT><\/FONT> <\/FONT>INDEX<\/FONT> SmallTableCI <\/FONT>ON<\/FONT> SmallTable <\/FONT>REBUILD<\/FONT><\/FONT>;
<\/FONT>GO<\/FONT><\/FONT><\/P>
\n

DBCC<\/FONT><\/FONT> IND <\/FONT>(<\/FONT>SItest<\/FONT>,<\/FONT> SmallTable<\/FONT>,<\/FONT> 1<\/FONT><\/FONT>);
<\/FONT>GO<\/FONT><\/P>
\n

DBCC<\/FONT><\/FONT> PAGE <\/FONT>(<\/FONT>SItest<\/FONT>,<\/FONT> 1<\/FONT>,<\/FONT> 143<\/FONT>,<\/FONT> 3<\/FONT><\/FONT>); <\/FONT>— page changed when we rebuilt the index
<\/FONT><\/FONT>GO<\/FONT><\/P>
\n

PageFID PagePID     IAMFID IAMPID      ObjectID    IndexID
——- ———– —— ———– ———– ———–
1       152         NULL   NULL        2073058421  1
1       143         1      152         2073058421  1<\/FONT><\/P>
\n

(2 row(s) affected)<\/FONT><\/P>
\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/FONT><\/P>
\n

PAGE: (1:143)<\/FONT><\/P>
\n

<SNIP SNIP SNIP><\/FONT><\/P>
\n

Slot 0 Offset 0x60 Length 15<\/FONT><\/P>
\n

Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP
Memory Dump @0x6209C060<\/FONT><\/P>
\n

00000000:   10000c00 01000000 01000000 0300f9 ……………
UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 0 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 1<\/FONT><\/P>
\n

Slot 0 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 1<\/FONT><\/P>
\n

Slot 1 Offset 0x6f Length 15<\/FONT><\/P>
\n

Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP
Memory Dump @0x6209C06F<\/FONT><\/P>
\n

00000000:   10000c00 02000000 02000000 0300f9 ……………
UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 1 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 2<\/FONT><\/P>
\n

Slot 1 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 2<\/FONT><\/P>
\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/FONT><\/P><\/FONT><\/FONT><\/FONT><\/BLOCKQUOTE><\/FONT>
\n

Nope – still nothing. Now I’ll force a versioning operation and we should see the tags. Any update to the table should cause versioned records to be created. In this case, I’ll start an explicit transaction and do some updates and we should be able to see the original values using another query window. First the updates:<\/P>
\n


\n

BEGIN<\/FONT><\/FONT> <\/FONT>TRAN<\/FONT>;
<\/FONT><\/FONT>GO<\/P><\/FONT>
\n

UPDATE<\/FONT><\/FONT> SmallTable <\/FONT>SET<\/FONT> c1 <\/FONT>=<\/FONT> 4<\/FONT>;
<\/FONT><\/FONT>GO<\/FONT><\/P><\/BLOCKQUOTE>
\n

And in another window:<\/P>
\n


\n

SELECT<\/FONT><\/FONT> <\/FONT>*<\/FONT> <\/FONT>FROM<\/FONT> smalltable<\/FONT>;
<\/FONT><\/FONT>GO<\/FONT><\/FONT><\/P>
\n

c1          c2
———– ———–
1           1
2           2<\/FONT><\/P>
\n

(2 row(s) affected)<\/FONT><\/P><\/BLOCKQUOTE>
\n

Cool – so the original values are still there. Let’s see the versioning info on the data page (output snipped again):<\/FONT><\/P>
\n


\n

DBCC<\/FONT> PAGE <\/FONT>(<\/FONT>SItest<\/FONT>,<\/FONT> 1<\/FONT>,<\/FONT> 143<\/FONT>,<\/FONT> 3<\/FONT><\/FONT>);
<\/FONT>GO<\/FONT><\/P>
\n

<\/FONT>PAGE: (1:143)<\/FONT><\/P>
\n

<SNIP SNIP SNIP><\/FONT><\/P>
\n

Slot 0 Offset 0x7e Length 29<\/FONT><\/P>
\n

Record Type = GHOST_DATA_RECORD      Record Attributes =  NULL_BITMAP VERSIONING_INFO<\/STRONG><\/FONT><\/P>
\n

Memory Dump @0x61CEC07E<\/FONT><\/P>
\n

00000000:   5c000c00 01000000 01000000 0300f9e0 \\……………
00000010:   00000001 00000057 03000000 00       …….W…..<\/FONT><\/P>
\n

Version Infomation =
 Transaction Timestamp: 855
 Version Pointer: (file 1 page 224 slot 0)<\/STRONG><\/FONT><\/P>
\n

UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 0 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 1<\/FONT><\/P>
\n

Slot 0 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 1<\/FONT><\/P>
\n

Slot 1 Offset 0xb8 Length 29<\/FONT><\/P>
\n

Record Type = GHOST_DATA_RECORD      Record Attributes =  NULL_BITMAP VERSIONING_INFO<\/STRONG><\/FONT><\/P>
\n

Memory Dump @0x61CEC0B8<\/FONT><\/P>
\n

00000000:   5c000c00 02000000 02000000 0300f9e0 \\……………
00000010:   00000001 00010057 03000000 00       …….W…..<\/FONT><\/P>
\n

Version Infomation =
 Transaction Timestamp: 855
 Version Pointer: (file 1 page 224 slot 1)<\/STRONG><\/FONT><\/P>
\n

UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 1 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 2<\/FONT><\/P>
\n

Slot 1 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 2<\/FONT><\/P>
\n

Slot 2 Offset 0x9b Length 29<\/FONT><\/P>
\n

Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VERSIONING_INFO<\/STRONG><\/FONT><\/P>
\n

Memory Dump @0x61CEC09B<\/FONT><\/P>
\n

00000000:   50000c00 04000000 01000000 0300f800 P……………
00000010:   00000000 00000057 03000000 00       …….W…..<\/FONT><\/P>
\n

Version Information =
 Transaction Timestamp: 855
 Version Pointer: Null<\/STRONG><\/FONT><\/P>
\n

UNIQUIFIER = [NULL]<\/FONT><\/P>
\n

Slot 2 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 4<\/FONT><\/P>
\n

Slot 2 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 1<\/FONT><\/P>
\n

Slot 3 Offset 0xd5 Length 37<\/FONT><\/P>
\n

Record Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP VARIABLE_COLUMNS VERSIONING_INFO<\/STRONG><\/FONT><\/P>
\n

Memory Dump @0x61CEC0D5<\/FONT><\/P>
\n

00000000:   70000c00 04000000 02000000 0300f801 p……………
00000010:   00170001 00000000 00000000 00000057 ……………W
00000020:   03000000 00                         …..<\/FONT><\/P>
\n

Version Information =
 Transaction Timestamp: 855
 Version Pointer: Null<\/STRONG><\/FONT><\/P>
\n


Slot 3 Column 0 Offset 0x13 Length 4<\/FONT><\/P>
\n

UNIQUIFIER = 1<\/FONT><\/P>
\n

Slot 3 Column 1 Offset 0x4 Length 4<\/FONT><\/P>
\n

c1 = 4<\/FONT><\/P>
\n

Slot 3 Column 2 Offset 0x8 Length 4<\/FONT><\/P>
\n

c2 = 2<\/FONT><\/P>
\n

DBCC execution completed. If DBCC printed error messages, contact your system administrator.<\/FONT><\/P><\/BLOCKQUOTE>
\n

I’ve marked the versioning parts in bold. Notice that the old records have been turned into ghost records too. The second record is now tagged as having variable-length columns too. This is because I updated both records to have the same clustering key value and so the second record now needs a uniquifier – which is stored as a variable-length column.<\/FONT><\/P>
\n

So, the original statement is a myth – the only time that rows get versioning info added to them is when it’s needed to support a versioning operation.<\/P><\/FONT><\/FONT><\/FONT><\/FONT><\/p>\n","protected":false},"excerpt":{"rendered":"

Ok – so we did more partying than we thought so blog posts have been a little sparse this month, but here’s one to end off the year. There’s a popular impression that turning on snapshot isolation and then rebuilding indexes will cause all rows in the table to get the extra 14-byte versioning tags. […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,48,62,82],"tags":[],"class_list":["post-1112","post","type-post","status-publish","format-standard","hentry","category-example-scripts","category-inside-the-storage-engine","category-on-disk-structures","category-snapshot-isolation"],"yoast_head":"\nInside the Storage Engine: When do versioning tags get added? - Paul S. Randal<\/title>\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.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Inside the Storage Engine: When do versioning tags get added? - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Ok – so we did more partying than we thought so blog posts have been a little sparse this month, but here’s one to end off the year. There’s a popular impression that turning on snapshot isolation and then rebuilding indexes will cause all rows in the table to get the extra 14-byte versioning tags. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2007-12-31T20:53:00+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/\",\"name\":\"Inside the Storage Engine: When do versioning tags get added? - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2007-12-31T20:53:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Inside the Storage Engine: When do versioning tags get added?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Inside the Storage Engine: When do versioning tags get added? - Paul S. Randal","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.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/","og_locale":"en_US","og_type":"article","og_title":"Inside the Storage Engine: When do versioning tags get added? - Paul S. Randal","og_description":"Ok – so we did more partying than we thought so blog posts have been a little sparse this month, but here’s one to end off the year. There’s a popular impression that turning on snapshot isolation and then rebuilding indexes will cause all rows in the table to get the extra 14-byte versioning tags. […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/","og_site_name":"Paul S. Randal","article_published_time":"2007-12-31T20:53:00+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/","name":"Inside the Storage Engine: When do versioning tags get added? - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2007-12-31T20:53:00+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-when-do-versioning-tags-get-added\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Inside the Storage Engine: When do versioning tags get added?"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=1112"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1112\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=1112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=1112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=1112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}