question about partition switching

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
February 12th, 2015 2:27pm

The query for 2015-01-23 return 0 records.


And how did you queried this?
Free Windows Admin Tool Kit Click here and download it now
February 13th, 2015 2:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics