I have been asked to script out the creation of specific tables in the database including primary key, nonclustered indexes, all constraints, and statistics. I am almost done with it except for the update statistics.
I can't find any information on how to find (or create) the hex stats_stream on a specific statistic. Anyone know how that is created?
I need the stats_stream, rowcount, and pagecount.
UPDATE STATISTICS [dbo].[StgVendItem]([XIE1StgVendItem]) WITH STATS_STREAM = 0x01000000040000000000000000000000B98268400000000088000000000000000000000000000000380100003800000004000A00000000000000000000000000A7020000A70000000C0000000000000008D0003400000000A7020000A70000001E0000000000000008D0003400000000380100003800000004000A00000000000000000000000000, ROWCOUNT = 0, PAGECOUNT = 0