SQL Server

  • 1,429 Blog Articles
Options
1,225
David-Engel on Apr 28 2021 04:14 PM
1,844
David-Engel on Apr 19 2021 09:00 AM
2,084
amvin87 on Apr 07 2021 10:58 AM
2,122
SrinivasSQL on Apr 06 2021 04:52 PM
1,414
David-Engel on Mar 31 2021 04:44 PM
2,538
HristinaSQL on Mar 29 2021 03:40 PM
12.3K
Pam Lahoud on Mar 29 2021 09:00 AM
4,463
David-Engel on Mar 16 2021 09:45 AM
2,389
David-Engel on Mar 10 2021 03:42 PM
1,555
David-Engel on Mar 10 2021 02:54 PM
1,742
David-Engel on Mar 03 2021 02:46 PM
1,332
David-Engel on Mar 02 2021 03:20 PM
2,106
HristinaSQL on Feb 24 2021 04:27 PM
1,992
zimwang_1993 on Feb 23 2021 08:42 AM
2,343
EbruErsan on Feb 23 2021 03:16 AM
2,210
SrinivasSQL on Feb 11 2021 02:11 PM
1,849
HristinaSQL on Feb 11 2021 01:30 PM
2,554
AndreasWolter on Feb 04 2021 03:54 AM
1,978
David-Engel on Jan 29 2021 03:47 PM
2,647
David-Engel on Jan 29 2021 03:39 PM
2,466
David-Engel on Jan 29 2021 03:36 PM
2,801
SQLTom on Jan 12 2021 12:08 PM
2,090
SQLTom on Jan 12 2021 12:06 PM
1,974
SQLTom on Jan 12 2021 12:04 PM
2,237
SQLTom on Jan 12 2021 12:03 PM
2,400
SQLTom on Jan 12 2021 12:01 PM
1,342
SQLTom on Jan 12 2021 11:59 AM
1,446
SQLTom on Jan 12 2021 11:58 AM

Latest Comments

I'm going to answer my own question for those who may follow. After some experimentation, it appears that "cleanup_version" is related to the version number from change tracking itself, like the number you might get from callingselect CHANGE_TRACKING_CURRENT_VERSION()So, if your change tracking vers...
0 Likes
I guess I still have a question on the finer points of this integer version number. Is this counter reset to zero when cleanup occurs? Based on your comment it sounds like that's the case, and If so then it really is an edge case and we'll have no issue with it. Thank you for your replies though! Th...
1 Likes
Thanks for posting this article, I'm surprised this user case hasn't been mentioned more on the tech community and MSDN bulletins considering pretty much everyone is working with JSON data these days!Anyway it saved me some time in trying to figure out the syntax when using OPENJSON with MERGE state...
0 Likes
@Lawrence_Smith and @petervee This is the number of outstanding versions to cleanup. So only systems that generate a number of versions > positive integer limit would encounter this, as stated in the Cause section of KB5007039 - FIX: You encounter error messages 8114 or 22122 when performing change ...
0 Likes
What is meant by "busy system"? "After a busy system that uses change tracking is enabled, the cleanup version can cross a range of INT in a given interval." What is this given interval?
1 Likes