Once partition numaralarına bakalim SELECT partition_number, rows FROM sys.partitions WHERE OBJECT_NAME(OBJECT_ID)='prItemBarcode'; GO VEYA SELECT $PARTITION.[pfnc_prItemBarcode](CreatedDate) AS Partition, COUNT(*) AS [COUNT] FROM [dbo].[prItemBarcode] GROUP BY $PARTITION. [pfnc_prItemBarcode](CreatedDate) ORDER BY Partition ; Sonra 4-7 arasındaki partitionları truncate edelim TRUNCATE TABLE [dbo].[prItemBarcode] WITH (PARTITIONS (4 TO 7)); GO
