THEN 'ALTER TABLE ' + OBJECT_SCHEMA_NAME(pstats.object_id) + '.' + OBJECT_NAME(pstats.object_id) + ' REBUILD PARTITION = ' + CONVERT(VARCHAR(5), pstats.partition ...

INNER JOIN sys.indexes AS i ON t.object_id = i.object_id INNER JOIN sys.partitions AS p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN sys.partition_schemes AS s ON ...

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...