hi folks,
I was doing some partition switching yesterday via the following command
set nocount on alter table express.[log] switch partition 3..18 to express.[LogPartition] partition 3..18 truncate table express.logpartition set nocount off
3..18 is the range of partition I ran the command thru.
afterward, i would run the following command
select $PARTITION.[ExpressLogPF](datetime) as Partition , count(*) as [count] from express.[log] group by $PARTITION.[ExpressLogPF](datetime) order by partition
I see the following:
when I query the table for data in partition 3, no data is returned. And when I run the following query, the min and max datetime is still showing jan 2014
The query for 2015-01-23 return 0 records.
Can someone explain to me why I'm seeing a count for partition 3..18 and that the select statement still show a min value of 2015-01-23?
Thanks
- Edited by Red8Rain 16 hours 5 minutes ago