I ran the average page fullness using sys.dm_db_index_physical_stats along with some other columns which are displayed in the attached screenshot

i see that is_read_committed_snapshot_on is set to 0

Hi Jeff

Apologies for delaying in replying. Ive been ill with a bad cold .

This is what I see of the the table when i run sp_help 'dbo.SIData_222222_88_20211103_1436'

I ran that and got a totalspacemb of 318.95

I ran that and got a totalspacemb of 318.95 MB

Hi Jeff

I also used

sp_spaceused 'dbo.SIData_222222_88_20211103_1436' but got the following stats

I used that to check against a manual calculation. If you look at the excel attachment to this...

sure the table DDL is

CREATE TABLE [dbo].[SIData_222222_88_20211103_1436](

[ReadingDateTime] [datetime2](2) NULL,

[ReadingValue] [real] NULL

) ON [PRIMARY]

On running your command i get the following for rowcount

10000000

There is no clustered index on the table or columnstore

After doing the Rebuild I got a size  318.883 MB     so thats way above my calculation

Hi Jeff

Apologies for not replying earlier. I have been on holiday

Yes it worked perfectly . Thank you very much for that.

You mentioned indexing....yes this is something next I want to...

Hi  Mike01

Brilliant that works perfectly for me. Thank you very much for that.

Thank you very much Eddie and Brian for your help on this

I went with Eddies approach and then scaled it up to a table of 1.5 million records

The performance using...

Hi Steve

Thank you very much for that. Thats a very elegant solution because it captures the interval midway between the 10 and 11th record in each group

Hi Scott

That worked very well for me. Thank you very much.

I re-wrote that query in Dyamic SQL. I work out the recordcount and then divide that by 800 , to...

Hi Mark

Briiliant that works very well. Thank you very much for doing that.

I can see what you are doing

@DataSheetXML.nodes('Datasheet/ChannelList/ChannelDefinition[@IsEnableable="True"]') x(r) --> Subselects the group to query on

Then x.r.value('(SensorScaling/OutUnits)[1]','varchar(20)') will extract...

Hi Mark

That works perfectly for me. Thank you very much