State File Demystified
Posted: Fri Jul 26, 2013 4:04 pm
The State file is a binary data file that stores an uint32 or uint64 value depending on your operating system. in a 64 bit platform , it stores an uint64 value in each 8 byte block of data per node. To read current values of a surrogate key state file , you can use the unix command od -xc <state File name> or use a sequential file , whose schema has a single uint 64 column [BigInt unsigned , unbounded, Data format=binary, field width = 8] , with Format property record type as implicit , you can see the currently stored values using view data. Not sure if this will help anybody or can be of much use , but my attempt to demystify those mysterious state files and their 'garbage' data.